Page History

The Analysis History tab on the SQL Doctor dashboard allows you to access the results of every analysis stored by SQL Doctor for your registered SQL Server instances. Analyses Analysis are ordered by start time per the local computer running the SQL Doctor console, and include:

• the The name of the analyzed analysed server
• time stamp Timestamp when the analysis started
• total Total time the analysis ran (duration in minutes)
• type Type of analysis performed
• total Total number of recommendations found
• highest Highest priority recommendation associated with the analysis

View recommendations

You can view the list of recommendations found for a specific analysis by double-clicking the analysis you want to investigate.

Delete an analysis

You can To delete an analysis by selecting , select one or more analyses analysis from the list, and then clicking click Delete. This action permanently removes the corresponding analysis data from the SQL Doctor Repository.

You can specify how long you want to keep your analyses analysis before SQL Doctor deletes them. By default, SQL Doctor stores each analysis in the Repository database for 30 days. To change this setting, click the Keep history for 30 days link. Keep in mind that this setting is a global setting that applies to all analyses the performed analysis on all registered SQL Server instances.

SQL Doctor also allows you to schedule an analysis to run daily or weekly at the specified time. To automate your analysesanalysis, click Schedule analysis on the SQL Doctor toolbar.

...