Workload Analysis targets the Index Optimization and Query Optimization performance categories. Workload analysis provides recommendations for these two categories which use a high amount of performance resources when running.
You can also select the Index Optimization and Query Optimization performance categories when running a regular analysis. This analysis focuses on lighter recommendations compared to the heavier ones from workload analysis. |
To run a workload analysis:
Select a recommendation and detail information displays in the recommendation details pane.
Do not click the Scheduling Enabled check box, unless you want to schedule a regular workload analysis on your SQL Server instance. |
To fine-tune your workload analysis results, you can block a particular recommendation or database. For additional information see, Fine-tune your analysis. |
Block a particular recommendation or recommendations to fine-tune your analysis.
Export your recommendations in .xls
file format.
Copy your recommendations to the clipboard so that you can view the text in a text editor.
Email your analysis results with recommendations.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|