Page History
The Recommendations view provides a list of performance recommendations based on the analysis SQL Doctor ran using your specific criteria. These recommendations result from a full analysis. You can also view quick findings for currently-occurring issues.
Info |
---|
SQL Doctor uses a recommendation engine from SQL Diagnostic Manager which helps you ease the updates between these two products. |
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.
Scroll pdf ignore | ||||||
---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Doctor provides complete SQL performance tuning. Learn more > >
...