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:
The Restore Database dialog, with our input, appears as shown in Illustration 7.
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.
We see the new ANSYS087_AS database appear in the Object Browser, as shown in Illustration 9.
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.
Lets 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.
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.
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.
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.