Analyzing and Optimizing Performance

Analysis Services (SQL Server 2000)

Microsoft® SQL Server™ 2000 Analysis Services provides tools that you can use to analyze and optimize the performance of your Analysis Services installation.

Topic	Description
Analyzing Usage Patterns	Describes the Usage Analysis Wizard. You can use this wizard to generate performance reports.
Optimizing Performance Based on Usage	Describes the Usage-Based Optimization Wizard. You can use this wizard to optimize aggregation design based on past queries.
Optimizing the Data Warehouse Database for Analysis Services Performance	Discusses techniques you can use when designing your data warehouse that will improve the performance of Analysis Services.
Optimizing Cube Schemas	Discusses the Optimize Schema option for cubes and how it can substantially reduce cube processing time.
Monitoring Analysis Services Performance	Details performance objects, counters, and instances you can use with Microsoft Windows 2000® System Monitor (known as Performance Monitor in Windows NT® 4.0) to monitor the performance of Analysis servers.