Add AppInsight for SQL to a named SQL instance
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 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 Derver Details pages. See Display AppInsight for SQL data in the Orion Web Console 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:
- Open a command prompt.
- Ping the server name:
Make note of the returned IP address so you can use it to add the server as a monitored node.
- Close the command prompt.
Add the node manually with AppInsight for SQL
- Click Settings > All Settings > Add Node.
- Enter the VIP address for the SQL named instance for the Polling Hostname or IP Address.
- Select a polling method, then select the polling engine for that node.
On the Choose Resources panel, check the appropriate AppInsight Application for the SQL server you will monitor.
- Complete the steps making selections as desired such as specific metrics or custom polling engines.
- Review and adjust any settings and click Add Node.
Navigate to the All Applications widget and click your AppInsight for SQL application.
The Enter Credentials screen displays.
- Enter your SQL credentials and select a port (or use the default port).
- Click Test to verify the credentials and configured permissions.
- Click Assign Credential to save and complete configuration.