Page History
...
- Click Add Server on the SQL Doctor toolbar.
- On 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.
| Info |
|---|
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. |
| Note |
|---|
Click Advanced Connection Settings on the Add Server window to configure how SQL Doctor collects performance counters from your instance. |
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Doctor provides complete SQL performance tuning. Learn more > >
...