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. Analysis Analyses are ordered by start time per the local computer running the SQL Doctor console, and include the following information:
- The name of the analysed 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 list of recommendations Recommendations List for a specific analysis by , double-clicking the analysis you want to investigate.
Delete an analysis
To You can delete an analysis , select by selecting one or more analysis analyses from the list, and then click 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 analysis 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 the analyses 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 analysisanalyses, click Schedule analysis on the SQL Doctor toolbar.
Scroll pdf ignore | ||||||
---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Doctor provides complete SQL performance tuning. Learn more > >
...