Monitor a SQL named instance with AppInsight for SQL

A named SQL instance is a SQL server given a name consisting of the network name of the server plus the instance name specified during installation. To monitor SQL named instances in SAM with AppInsight for SQL, you need the Virtual IP (VIP) of the SQL server and the full name.

Before adding the server as a node, verify the credentials and permissions are configured on the target SQL server.

You may need to log in with an administrator account to perform this action.

To view monitored nodes, access the SQL Server page and specific SQL server details pages. See Monitor with AppInsight for SQL for details.

The instance becomes enabled after the first poll, which may take a few minutes.

Locate the VIP for the server

If you do not know the VIP, follow these steps to ping the server:

  1. Open a command prompt.
  2. Ping the server name: ping NAME.
  3. Make note of the returned IP. You will use this IP when adding the server as a monitored node.

  4. Close the command prompt.

Add the node manually with AppInsight for SQL

With the VIP, add the named SQL instance as a node for monitoring. These instructions manually add the node. You can also use the Discovery Wizard. For details, see Add AppInsight for SQL to a node.

  1. In the Orion Web Console, click Settings > All Settings > Add Node.
  2. Enter the VIP address for the SQL named instance for the Polling Hostname or IP Address.
  3. Select a polling method, then select the polling engine for that node.
  4. On the Choose Resources panel, check the appropriate AppInsight Application for the SQL server you will monitor.

  5. Complete the steps making selections as desired such as specific metrics or custom polling engines.
  6. Review and adjust any settings and click Add Node.
  7. Navigate to the All Applications widget and click your AppInsight for SQL application.

    The Enter Credentials screen displays.

  8. Enter your SQL credentials and select a port (or use the default port).
  9. Click Test to verify the credentials and configured permissions.
  10. Click Assign Credential to save and complete configuration.