Versions Compared

Old Version 29

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Barrientos

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 current performance issues.

 Image Added  Image Removed

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

Tip

You can setup set up the Analysis categories, Analysis options, Scheduling, and other Advanced Settings in the Monitored SQL Server Properties window:

  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. For more information, review Configure your prescriptive analysis options.
  3. Click OK.

...

Flagging a recommendation allow allows 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 to easily find the recommendation later. 

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

 Image Added  Image Removed

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, a Image Removed displays next Optimize Script, displays next to the optimized recommendation.

...