Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Usage-Based Optimization Wizard

SQL Server 2000

Usage-Based Optimization Wizard

Use this wizard to tune performance of cube partitions based on the history of queries previously sent to the cube.

For more information about optimizing performance, see Scalability.

The Usage-Based Optimization Wizard appears when, in the Analysis Manager tree pane, you right-click an existing cube and then click Usage-Based Optimization.

The Usage-Based Optimization Wizard has the following steps:

  • Select the cube partition whose query performance you want to optimize.

  • Select the queries on which you want to base your optimization.

  • Review the results.

  • Choose whether to replace existing aggregations or to add new ones.

  • Select a type of data storage.

  • Design new aggregations.

  • Save and process the new aggregations.
© 2015 Microsoft