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:
- Right-click the appropriate SQL Server instance from the Servers tree and select Properties.
- Select Analysis Configuration when SQL Diagnostic Manager displays the Monitored SQL Server Properties window.
- Select only the Index Optimization and/or the Query Optimization performance categories.
- Click Run Workload Analysis in the Analyze tab.
- When the analysis is complete, SQL Diagnostic Manager provides a priority-ranked list of recommendations (Finding Text column).
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.
Additional actions
Block
Block a particular recommendation or recommendations to fine-tune your analysis.
Export
Export your recommendations in .xls file format.
Copy
Copy your recommendations to the clipboard so that you can view the text in a text editor.
Email
Email your analysis results with recommendations.