In this lesson, we will we will examine the source of cube performance statistics, the Query Log, discussing its location and physical structure, how it is populated, and other characteristics. Next, we will discuss ways that we can customize the degree and magnitude of statistical capture in the Query Log to enhance its value with regard to meeting more precisely our local analysis and reporting needs; we will practice the process of making the necessary changes in settings to illustrate how this is done. Finally, we will discuss options for generating more in-depth, custom reports than the wizard provides, exposing ways that we can directly obtain detailed information surrounding cube processing events in a manner that allows more sophisticated selection, filtering and display, as well as more customized reporting of these important metrics.

The topics within this article include:

• An examination of the Query Log, the source of cube performance statistics, including its location and physical structure, how it is populated, and other characteristics;
• Customization of the statistical capture in the Query Log to enhance its value in meeting local needs;
• Practice surrounding setting changes;
• A discussion of options for generating more in-depth, custom reports, including direct access of detailed information surrounding cube processing events to allow more sophisticated selection, filtering and display, as well as more customized reporting of these important metrics.

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.

Analysis Services, Usage, Utilization, Statistical, Analysis , Cube, Multidimensional, MSAS, MS Access, Reporting, PivotTable
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.