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:
- Right-click the appropriate monitored SQL Server instance and select Properties > Analysis Configuration.
- On the Setup Analysis Categories and Options window, under the Scheduling section, click the Scheduling Enabled check box.
- Select the days and time you want the analysis to start. For best results, select a time when the SQL Server instance is busy.
The specified days and time only apply to prescriptive analysis. Workload analysis is not impacted by this feature.
- Specify the total Duration (in minutes) that you want SQL Diagnostic Manager to take collecting and analyzing data from this server.
The specified duration only applies to workload analysis. Prescriptive analysis is not be impacted by this feature.
- Click OK.
By default, SQL Diagnostic Manager performs a full analysis for five minutes.
To cancel an analysis:
- Right-click the appropriate monitored SQL Server instance and select Properties > Analysis Configuration.
- On the Setup Analysis Categories and Options window, under the Scheduling section, clear the Scheduling Enabled check box.