Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can configure the SQL Doctor settings for each registered server. The In the main windows of SQL Doctor console you can find the following configuration options are available:

Add Server

Add a SQL Server instance to analyze performance issues

The Add Server window lets you register a SQL Server instance with SQL Doctor and set up the basic options you need to get started with an analysis.

Server Settings

Change general server settings

The General Settings tab lets you select the location where you want to store the results of your analysis, the credentials that you want SQL Doctor to use when connecting to your server, and additional data collection options.

Block specific recommendations

The Block Recommendations tab lets you select the recommendations you no longer want to receive.

Block specific databases

...

Tip

When adding a SQL Server instance you can choose a cloud provider for your monitored SQL Server instances that are hosted on the cloud. SQL Doctor supports Amazon RDS and Microsoft SQL Azure.

Remove Server

Remove server

...

The Schedule analysis link lets you create or edit the analysis schedule for a SQL Server instance.

 

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

...

Diagnose Queries

Running Diagnose Queries

This window helps you save time by analyzing the queries you care about without having to wait for a full analysis to complete. When SQL Doctor diagnoses a query, you receive performance recommendations without actually executing it.



Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...