Page History
...
- 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.
Note 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.
Note The specified duration only applies to workload analysis. Prescriptive analysis is not be impacted by this feature.
- Click OK.
Tip |
---|
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.
...