You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

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:

  1. Right-click the appropriate SQL Server instance from the Servers tree and select Properties.
  2. Select Analysis Configuration when SQL Diagnostic Manager displays the Monitored SQL Server Properties window.
  3. Configure your prescriptive analysis options.

  4. Click Run Analysis in the Analyze tab.
  5. When the analysis is complete, SQL Diagnostic Manager provides a priority-ranked list of recommendations (Finding Text column)

  6. Select a recommendation to have detail information displayed 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

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.


SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
  • No labels