Page History
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.
...