Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...

Scroll pdf ignore
SQL Doctor provides complete SQL performance tuning. Learn more > >