When configuring your analysis, you can select any combination of performance categories to focus the analysis. Each category contains a set of performance metrics and their related recommendations. By picking a category, you are identifying which SQL Server areas concern you most.
Based on the chosen categories, SQL Diagnostic Manager polls your target SQL Server instance to gather the appropriate metrics and determine which recommendations match the server's current performance issues.
To run an 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.
- Click Run 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 analysis on your SQL Server instance.
To fine-tune your 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.