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. To get the most out of this feature, IDERA recommends that you schedule the analysis to run during busy periods or during times your SQL Server users are experiencing problems.
To schedule an analysis:
The specified days and time only apply to prescriptive analysis. Workload analysis is not impacted by this feature. |
The specified duration only applies to workload analysis. Prescriptive analysis is not be impacted by this feature. |
By default, SQL Diagnostic Manager performs a full analysis for five minutes. |
To cancel an analysis:
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|