Documentation forServer & Application Monitor

Add AppInsight for SQL to an active SQL Server cluster node

If your SAM environment includes clustered SQL servers, perhaps for high availability purposes, you can use AppInsight for SQL to monitor active cluster nodes.

Before you begin, review AppInsight for SQL requirements and note these details about the Orion agent for Windows:

  • Agents do not work with AppInsight for SQL if the SQL server is monitored in a cluster.
  • SQL clusters cannot be polled with domain credentials via the Orion agent because agents do not work with AppInsight for SQL if the SQL server is monitored in a cluster.

First, identify the IP address of the cluster.

  1. Use SQL Management Studio to connect to the instance that you want monitor .
  2. Execute the following query to verify the target node and instance name:

    SELECT SERVERPROPERTY('ServerName')
  3. Determine the IP address of the target node.

    Open a command prompt and ping the server: ping NAME. In the following example, ping P111SQLV23 determined that the IP address was 10.1.70.123.

Next, add the node to the Orion Platform and assign AppInsight for SQL.

  1. Click Settings > All Settings > Add Node.
  2. Enter the IP address for the SQL cluster for the Polling Hostname or IP Address.

    If the IP address represents a cluster, the node name of the active cluster member populates.

    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. In the Choose Resources step, select the AppInsight Application for the SQL server to monitor.

  5. Complete the wizard to add the node for monitoring. The instance becomes enabled after the first poll, which may take a few minutes.
  6. Navigate to the All Applications widget and click your AppInsight for SQL application to display the Enter Credentials page.

  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.