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

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.

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 Remove Server window lets you unregister one or more SQL Server instances from SQL Doctor.

Analyze Server

Schedule an analysis

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

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.



SQL Doctor get advice and recommendations on how to tune SQL performance.
| | | | |