Page History

...

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).

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

6. Select a recommendation to have detail information displayed in the recommendation details pane.

   Tip
   To fine-tune your analysis results, you can block a particular recommendation or database. For additional information, see

...

1. Fine-tune your analysis.

Flag a Recommendation

Flagging a recommendation allow you to mark it for a 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 easily find the recommendation later.

...