Use the Add Server window to register a SQL Server instance with SQL Doctor. By adding a server to SQL Doctor, you can schedule when analyses are performed, as well as run analyses on an as-needed basis.
To run an analysis on your SQL Server instance, you must specify either system administration level SQL Server credentials or be currently logged in to a Windows account with system administrator level credentials on the SQL Server instance you want to analyze.
To access the Add Server window, click Add Server on the SQL Doctor toolbar.
To add a server:
When you analyze a Cloud Instance hosted by Amazon RDS SQL Server, an Access Key and a Secret Key are required. The Access Key and Secret Key are used to access Amazon APIs to get at various platform-specific information including OS metrics via the REST protocol. |
Click Advanced Connection Settings on the Add Server window to configure how SQL Doctor collects performance counters from your instance. |
SQL Doctor get advice and recommendations on how to tune SQL performance.| | | | | | | |