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.
To run an analysis:
- Click Run Analysis in the Analyze tab.
- 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.
- Once you finished with the Analysis configuration, click Run Analysis to start with the Analysis, or click Cancel if you want to cancel the Analysis
- Right-click the appropriate SQL Server instance from the Servers tree and select Properties.
- Select Analysis Configuration when SQL Diagnostic Manager displays the Monitored SQL Server Properties window.
- Click Run Analysis in the Analyze tab.
When the analysis is complete, SQL Diagnostic Manager provides a lists all the performed analysis results by date.
Double-click any of the Analysis to review the 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. Select a recommendation to have detail detailed information which is 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 Fine-tune your analysis.
You can setup the Analysis categories, Analysis options, Scheduling, and other Advanced Settings in the Monitored SQL Server Properties window:
|
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.
To flag recommendations, click the Flag icon next to the recommendation you want to flag.
Scripts
Optimize Script
Some recommendation has the Optimize Script option enabled. The Optimize Now window displays the script that 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
displays next to the optimized recommendation....
Warning |
---|
Executing the undo script on a recommendation that is not already optimized can harm your SQL Server SQL Server environment. Before executing the undo script, be sure that the corresponding optimization is performed. |
...
The Show Problem button launches the SQL Viewer SQL Viewer window with the SQL text associated with the recommendation highlighted.
...
Email your analysis results with recommendations.