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:
When the analysis is complete, SQL Diagnostic Manager provides a priority-ranked list of recommendations (Finding Text column).
Flagging a recommendation allows you to mark it for follow-up action. Use flags to identify recommendations that require further investigation or that you want to optimize at a later time. Whenever you flag a recommendation this action is saved to the analysis file, allowing you to find the recommendation later. Click the Flag icon next to the recommendation you want to flag. |
Select a recommendation and detail information displays in the recommendation details pane.
To fine-tune your 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 > >
|