Page History
...
By default, SQL Doctor lists recommendations by priority. The priority of a recommendation is determined by the performance gain you receive from making the suggested change, how relevant it is the parameters you specified when configuring the analysis, and the confidence SQL Doctor has in the recommendation.
Highest priority recommendation
Lowest priority recommendation
Use the left pane navigation tree to narrow the recommendations by:
...
- Select the recommendations you want to include in your export.
- Select either Export or Email on the Recommendations toolbar menu.
Use Show me the problem and Optimize script
SQL Doctor allows you the opportunity to perform the following actions, when applicable:
Show me the problem
Opens a SQL Viewer window displaying the problematic part of the SQL script that generated the recommendation.
Optimize Script
Opens the Optimize Now window, displaying the SQL script used to fix the detected problem. Click Run to fix the problem.
Undo Script
Opens the Undo Optimization window, displaying the SQL script used to undo the previously executed optimization. Click Run to undo the previous optimization.
...
You can schedule an analysis to run automatically on a daily or weekly timeframe. To schedule the next analysis, click Schedule analysis on in the SQL Doctor toolbar.
SQL Doctor provides complete SQL performance tuning. Learn more > >