Cube Storage: Planning Partitions from a SQL Server Management Studio Perspective - Page 3

December 11, 2009

22.  Type the following into the Restore database box immediately above the Storage location box in the Restore Target section:

ANSYS087_AS

The Restore Database dialog, with our input, appears as shown in Illustration 7.

The Completed Restore Database Dialog
Illustration 7: The Completed Restore Database Dialog

23.  Click OK to initiate the restoration.

The Restore Database dialog grays, as the Executing symbol in the Progress pane, once again, becomes active. The process runs, and, once completed, the dialog closes, returning us to the Management Studio.

24.  Within the Object Explorer, right-click the Databases folder underneath the Analysis Server name, once again.

25.  Select Refresh... from the context menu that appears, as depicted in Illustration 8.

Right-click the Databases Folder – Select Refresh
Illustration 8: Right-click the Databases Folder – Select Refresh ...

We see the new ANSYS087_AS database appear in the Object Browser, as shown in Illustration 9.

The New Database Appears
Illustration 9: The New Database Appears ...

Having finished the preceding steps, we are now ready to access the new Analysis Services database we have created within the SQL Server Management Studio. Here, we are positioned to take a look at some of the options available for resource assignment and partition settings, which we will examine as a part of our discussion surrounding partition planning.

Note: We examined similar options available for resource assignment and partition settings from a Business Intelligence Development Studio perspective in Cube Storage: Planning Partitions (Business Intelligence Development Studio Perspective), as mentioned above. To see similar settings to those we examine below in Business Intelligence Development Studio, please see that article.

Let’s focus, at this point, upon the Adventure Works cube, within the clone Analysis Services database we have created, and begin setting ourselves up for our review in the next section with the following steps:

26.  In the Object Explorer of the Management Studio, once again, expand the ANSYS087_AS database that we created earlier by clicking the “+” sign to its immediate left.

27.  In similar manner, expand the Cubes folder that appears underneath the newly expanded database.

Folders for the two cubes in the sample database, Adventure Works and Mined Customers (a data mining cube) appear, as depicted in Illustration 10.

The Folders for the Cubes of Our New Analysis Services Database Appear
Illustration 10: The Folders for the Cubes of Our New Analysis Services Database Appear ...

28.  Expand the Adventure Works cube.

The Measure Groups folder for the Adventure Works cube next appears. We recall that partitions, at least within our present context, are associated with measure groups. Hence it is easy to see why partition settings and properties are located where they are.

29.  Expand the Measure Groups folder.

The individual Measure Groups for the cube next appear, as shown in Illustration 11.

The Measure Groups for the Adventure Works Cube Appear
Illustration 11: The Measure Groups for the Adventure Works Cube Appear ...

30.  Expand the Internet Sales Measure Group, by clicking the “+” sign to its immediate left.

The Partitions, Writeback, and Aggregation Design folders appear, as depicted in Illustration 12.

The Partition, Writeback, and Aggregation Design Folders Appear
Illustration 12: The Partition, Writeback, and Aggregation Design Folders Appear ...

For purposes of this article, we will be working within the folders that appear above (most predominantly within the Partitions folder), where partitions can be conveniently constructed and maintained. Here we can perform settings and assignments related to storage, proactive caching, writeback, and more for each measure group within the cube, as we shall see.

We are now positioned to begin our discussion of partition planning, and our examination of some of the resource assignments and settings upon which our partition planning efforts can be based.








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers