The Block Databases tab of the Server Settings window lets you block SQL Server databases from being included in scheduled, ad-hoc, or real-time analyses. When a database is blocked, SQL Doctor does not return recommendations for it, and the database is not listed under the Databases node in the navigation pane.

Access the Block Databases tab of the Server Settings window

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

Block and unblock your databases

To block databases from appearing in your analysis:

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

To unblock databases to include them in your analysis:

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


IDERAProductsPurchase | Support | Community | Resources | About Us | Legal