The All Analyses view lists every available analysis performed on the selected SQL Server instance. Analyses are ordered by start time (per the local computer running the SQL Doctor Console) and include:
- The time stamp when the analysis started.
- The total time the analysis ran (duration in minutes).
- The type of analysis performed.
- The total number of recommendations found.
- The highest priority recommendation associated with the analysis.
Access the All Analyses view
You can access the All Analyses view for a SQL Server instance by expanding the directory tree for the instance, and then selecting All Analyses.
View recommendations
You can view the list of recommendations for a specific analysis by 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.