Optimization of MSAS requires an in-depth knowledge of many factors, including the manner in which MSAS executes queries within the client/server architecture that embodies it.   From the perspective of the cubes that MSAS produces, our primary concerns, from a performance standpoint, lie within two main groups:  cube processing performance (how fast the cube builds / updates from the source data) and cube query performance (the response time with which consumers’ needs are met with information contained in the cube) 

The structure of MSAS cubes themselves span many considerations; among the most significant concerns are storage modes and aggregations.  MSAS allows for management of these and other factors in numerous ways, including several tools within the application.  This article will focus on the Storage Design Wizard, and, as a natural part of exploring its use, we will consider and acknowledge the importance and potential complexity of storage configuration for MSAS.  The detailed topics of storage, aggregation, and a host of other considerations in tuning MSAS are beyond the scope of this article.  These and many other performance-related topics will be treated individually in other articles of my various series.

In this article, we will:

• Introduce the Storage Design Wizard, discussing its general purposes;
• Explore scenarios where we might use the Storage Design Wizard;
• Practice using the Storage Design Wizard in a basic scenario;
• Review cube processing;
• Discuss how the processing log can be used to focus on storage design effectiveness.

Read the Article ...

About the Series:

This article is a member of the series Introduction to MSSQL Server 2000 Analysis Services. The series is designed to provide hands-on application of the fundamentals of MS SQL Server 2000 Analysis Services, with each installment progressively adding features and techniques designed to meet specific real - world needs. For more information on the series, as well as the hardware / software requirements to prepare for the exercises we will undertake, please see my initial article, Creating Our First Cube.
MSAS, MSSQL, SQL, Server, cube, Analysis, Services, Aggregation, Partition, Storage, design, derived, calculated, measure, wizard, OLAP, MOLAP, ROLAP, HOLAP, modes, performance, optimization, MDX
All Contents Copyright Island Technologies Inc. ^®  Island Technologies^® and Island Technologies Inc.^®  are registered trademarks of Island Technologies Inc., protected in the United States and other countries.  For information, contact Island.