Add a server to analyze

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:

1. Click Add Server on the SQL Doctor toolbar.
2. On the Add Server window, select the SQL Server instance you want to add.
3. If this instance is being used as a production server, check Production Server.
4. If this instance has OLTP enabled, check Online Transaction Processing (OLTP).
5. 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.
6. Click Add.

 

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