Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Server & Application Monitor (SAM) > SAM Documentation > SAM 6.7.1 Administrator Guide > AppInsight for SQL in SAM > Monitor clusters with AppInsight for SQL

Monitor clusters with AppInsight for SQL

Table of contents
No headers

Updated: 3-9-2017

Your environment may include clustered SQL servers in your environment, such as for high availability. These clustered SQL servers can be added and monitored with AppInsight for SQL through SAM.

Agents do not work to poll AppInsight for SQL when the SQL server being monitored is in a cluster.

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 AppInsight for SQL for details.

This instance is grayed until the poller has polled this node. Once polled, the status color updates.

First, you need the IP address of the cluster.

  1. Connect to the instance that you want monitor using SQL Management Studio.
  2. Execute the following query to make sure you have the proper target node and instance name:
  3. Determine the IP address of the target node.
    Open a command prompt and ping the server: ping NAME. For example, ping P111SQLV23 in the following example. The IP address is determined to be


Next, add the node and assign AppInsight for SQL.

  1. On the Web Console, click Settings > All Settings >  Add Node.
  2. If the IP address represents a cluster, the node name of the active cluster member populates.
    Enter the IP address for the SQL cluster for the Polling Hostname or IP Address. 
    SolarWinds recommends changing the node name to something more easily understood during the final step of the Add Node Wizard. For example, for this cluster you could enter the name and (cluster): P111SQLV23 (cluster).          
  3. Select a polling method, then select the polling engine for that node.
  4. On the Choose Resources step, check the appropriate AppInsight Application for the SQL server to monitor.
  5. Complete the wizard as instructed to add the node for monitoring.
  6. Navigate to the All Applications resource and click your AppInsight for SQL application.
    The Enter Credentials screen displays.
  7. Enter your SQL credentials and select a port (or use default port).
  8. Click Test to verify the credentials and configured permissions.
  9. Click Assign Credential to save and complete configuration.
Last modified