Add AppInsight for SQL to a named instance

In SQL Server, 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 named instances with AppInsight for SQL, you need the Virtual IP (VIP) of the SQL server and the full name.

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

To view monitored nodes, access the SQL Server page and specific SQL Server Details pages. See Display AppInsight for SQL data in the SolarWinds Platform Web Console for details.

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

Locate the server's VIP address

If you do not know the VIP address, 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 address so you can use it to add 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 nodes.

1. 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, select the instance to monitor.

   

5. Follow onscreen instructions to select metrics to monitor and specify polling engines.
6. Review settings, and then click Add Node.

7. Navigate to the All Applications widget and click your AppInsight for SQL application.

   The Enter Credentials screen displays.

   

8. Enter SQL credentials and port details.
9. Click Test to verify the credentials and configured permissions.
10. Click Assign Credential to save changes.