Page History

...

The General Settings tab allows you to manage the following settings:

Store your analysis results

SQL Doctor stores the overall analysis summary information along with all the individual recommendations. Additionally, vital metric data is stored and compared against subsequent analysis data to see if changes have occurred that are negatively affecting SQL Server performance. Browse for and then select the location where you want to store your analysis results.

Enter your connection credentials

You can configure SQL Doctor to use either Windows or SQL Server Authentication to connect to the selected instance.

Select your analysis options

When performing an analysis, SQL Doctor takes into account whether the instance is a production server or , it has online transaction processing (OLTP) enabled, or it is a Cloud Instance (In this option, select Amazon RDS SQL Server or Microsoft Azure SQL Database). Specify whether you want SQL Doctor to use these options when analyzing the selected server.

Select your performance collection options

You can configure SQL Doctor to use either OLE automation or WMI to collect performance metrics from the selected instance. To configure the connection settings you want SQL Doctor to use for this server, click Advanced Connection Settings. Be sure to test your collection settings before you start the analysis.

...

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

...

...