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