Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Click Add Server on the SQL Doctor toolbar.
  2. 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.
  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. 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.
  6. 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.
  7. Click Add.
Info

In case When you choose analyze a Cloud Instance hosted by Amazon RDS SQL Server, the 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.

...