Export (0) Print
Expand All

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft