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.
Access the Add Server window
To access the Add Server window, click Add Server on the SQL Doctor toolbar.
Add a server to SQL Doctor
To add a server:
- Click Add Server on the SQL Doctor toolbar.
- In the Add Server window; in the Server name text box, select the SQL Server instance you want to add by clicking <Browse for more...>. Once the Browse for SQL Server window opens, select a local SQL Server instance or select a SQL Server instance on the network. Otherwise, you can enter the name of the SQL Sever instance you want to use in the Server name text box.
- If this instance is being used as a production server, check Production Server.
- If this instance has OLTP enabled, check Online Transaction Processing (OLTP).
- If this instance is hosted by a cloud instance, check Cloud Instance, and select which service the instance is hosted on, either Amazon RDS SQL Server or Microsoft Azure SQL Database.
- Choose the type of authentication this server requires, and then specify the appropriate Windows user account or SQL login credentials. By default, SQL Doctor uses the credentials of your currently logged on Windows account to access the target server. Ensure the specified account has the required permissions.
- Click Add.
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.
The Access Key and Secret Key are generated and managed using the Amazon AWS console by the Amazon account administrator.
Click Advanced Connection Settings on the Add Server window to configure how SQL Doctor collects performance counters from your instance.