The Schedule Analysis window allows you to schedule a regular SQL Doctor 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 SQL Doctor, IDERA recommends that you schedule the analysis to run during busy periods or during times your SQL Server users are experiencing problems.
By default, SQL Doctor performs a full analysis for five minutes, using the general settings defined for the target SQL Server instance. A full analysis collects and examines performance metrics from all available analysis categories.
SQL Doctor allows you to schedule a future analysis on a single SQL Server instance. You can perform manual analyses on an unlimited number of SQL Server instances. |
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.
To schedule an analysis:
To cancel a scheduled analysis:
SQL Doctor get advice and recommendations on how to tune SQL performance.| | | | | | | |