Analyzing and Optimizing Performance
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.
|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.|