The Block Recommendations tab of the Server Settings window lists all available SQL Doctor recommendations and indicates whether they are blocked. This list is server-specific, and can be customized per your unique diagnostic needs.

To reduce analysis "noise," consider blocking recommendations for changes that you do not plan to make in your environment. Blocking a recommendation removes the recommendation from all future analyses results for this registered instance.

Access the Block Recommendations tab of the Server Settings window

You can access the Block Recommendations tab of the Server Settings window by clicking Edit > Blocked Recommendations.

Block and unblock your recommendations

To block recommendations from appearing in your analysis:

  1. Access the Block Recommendations tab of the Server Settings window by clicking Edit > Blocked Recommendations.
  2. Check the Block box next to each of the recommendations you want to block from future analyses.
  3. Click OK.

To unblock recommendations to include them in your analysis:

  1. Access the Block Recommendations tab of the Server Settings window by clicking Edit > Blocked Recommendations.
  2. Scroll down the list of blocked recommendations and find the recommendation you want to unblock.
  3. Clear the Block box next to the recommendation.
  4. Click OK.

SQL Doctor provides complete SQL performance tuning. Learn more > >