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 are ordered by start time per the local computer running the SQL Doctor console, and include the following information:
- The name of the analyzed server
- Timestamp when the analysis started
- Total time the analysis ran (duration in minutes)
- Type of analysis performed
- Total number of recommendations found
- Highest priority recommendation associated with the analysis
View recommendations
You can view the Recommendations List for a specific analysis, double-clicking the analysis you want to investigate.
Delete an analysis
You can delete an analysis by selecting one or more analyses from the list, and then clicking 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 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 performed 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 analyses, click Schedule analysis on the SQL Doctor toolbar.