Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Dec 11, 2009

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

By William Pearson

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.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM