Page History

...

You can access the Schedule Analysis window by clicking Edit > Schedule Analysis or by clicking Schedule Analysis on the right side of the SQL Doctor toolbar.

Schedule an analysis

Image Added

To schedule an analysis:

1. Access the Schedule Analysis window by clicking Schedule Analysis on the right side of the SQL Doctor toolbar.
2. On the Schedule Analysis window, click Run a routine checkup of my SQL Server to enable scheduling.
3. Select the target SQL Server instance using the Server Name drop-down option.
4. Choose to run the analysis either daily or weekly using the Recurrence drop-down option.
5. Select the time you want the analysis to start using the local time of the SQL Doctor computer. For best results, select a time when the SQL Server instance is busy.
6. Specify the total Duration (in minutes) that you want SQL Doctor to take collecting and analyzing data from this server.
7. Click OK.

...

1. Access the Schedule Analysis window by clicking Schedule Analysis on the right side of the SQL Doctor toolbar.
2. On the Schedule Analysis window, select the target SQL Server instance using the Server Name drop-down option.
3. Clear the Run a routine check of my SQL Server check box.
4. Click OK. SQL Doctor displays a message alerting you that you are disabling the scheduled analysis checkup for a server.
5. Click Yes.