Page History

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 SQL Server areas concern you most.

Based on the chosen categories, SQL Diagnostic Manager polls your target SQL Server SQL Server instance to gather the appropriate metrics and determine which recommendations match the server's current performance issues.

...

 Image Added 

To run an analysis:

1. Click Run Analysis in the Analyze tab.
2. When the Run Analysis window opens, you can select all the categories depending on what you want to include in your analysis. In the Filters tab, you can include specific applications (% wildcard), limit your analysis to a single database, and set how long SQLDM should spend collecting diagnostic data.
   Image Added
3. Once you are finished with the Analysis configuration, click Run Analysis to start with the Analysis, or click Cancel if you want to cancel the Analysis.

4. When the analysis is complete, SQL Diagnostic Manager lists all the performed analysis results by date.

5. Double-click any of the Analyses to review the priority-ranked list of recommendations.

   Note
   SQLDM lists recommendations by priority. The priority of a recommendation is determined by the performance gain you receive from making the suggested change, and how relevant are the parameters you specified when configuring the analysis.

6. Select a recommendation to have detailed information.
   

...

...

Select a recommendation and detail information displays in the recommendation details pane.

Flag a Recommendation

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. When you flag a recommendation, this flagged state is saved to the analysis file, allowing you to easily find the recommendation later. 

To flag recommendations, click the Flag icon next to the recommendation you want to flag.

 Image Added 

Scripts

Optimize Script

Some recommendation has the Optimize Script option enabled. The Optimize Now window displays the script that was used to enact the recommended change. Review the script, to either Run it or Cancel to return to the recommendation you were viewing.

When you run the Optimize Script, displays next to the optimized recommendation.

Undo Script

The Undo Optimization window displays the script that is used to enact the recommended change. Review the script and either click the Run button to initiate the undo or click Cancel to return to the recommendation you were viewing. The undo script can be copied to the clipboard and used at a later time.

Show Problem

...

The Show Problem button launches the SQL Viewer window with the SQL text associated with the recommendation highlighted.

Additional actions

Block

Block a particular recommendation or recommendations to fine-tune your analysis.

...

Email your analysis results with recommendations.