Page History
...
SQL Diagnostic Manager allows you to schedule the days and time for a regular prescriptive analysis and/or specify the duration of a workload analysis on your SQL Server instance. Scheduled analyses are an important way to track the health of your SQL Server environment. For more information on this feature, see Schedule analysis.
Select categories
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. For additional information on the different categories, see Performance categories.
| Info |
|---|
The more categories you pick, the longer the analysis needs to run to ensure all relevant data has been collected and thoroughly analyzed. |
...
You can choose to block recommendations and databases from the analysis, as well as apply additional filters using the options available on the Server Settings window. To access this window, click the Advanced Settingsbutton on the Analysis Configuration tab.
...