Add AppInsight for SQL to a node

With the credentials and permissions configured on the target SQL server, quickly and easily add AppInsight for SQL to SQL servers through the Discover Wizard or manually. When added, you create a monitored node in SAM for the Microsoft SQL Server application. SAM polls the node for metrics including read and write latency, index fragmentation, expensive queries (based on CPU time), SQL agent job status with logs, capacity, and resource consumption for CPU, memory, and drive space.

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.

Add through the Discovery Wizard

Use the Discovery Wizard to add a new node and select AppInsight for SQL for monitoring.

  1. Click Settings > Discovery Wizard.
  2. In the Network panel, enter the IP addresses to scan through. Run through the screens as instructed.
  3. On the Applications panel, all detected and supported Microsoft SQL Servers display.

    Select the servers to add for monitoring as nodes. Only supported versions of Microsoft SQL are located and displayed for monitoring. To see all supported versions, see AppInsight for SQL requirements and permissions.

  4. Click Next and complete the wizard as instructed.
  5. Navigate to the All Applications resource and click your AppInsight for SQL application.

    The Enter Credentials screen displays.

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

Add an SQL server as a node manually

When added, you need to select the appropriate Microsoft SQL server version from the AppInsight Applications list.

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

  1. On the Web Console, click Settings > All Settings > Add Node.
  2. Enter the IP address or hostname for the SQL server. Select the polling method and continue.
  3. On the Choose Resources panel, check the appropriate AppInsight Application for the SQL server you will monitor.

  4. Complete the steps making selections as desired such as specific metrics or custom pollers.
  5. Review and adjust any settings and click Add Node.
  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 the default port).
  8. Click Test to verify the credentials and configured permissions.
  9. Click Assign Credential to save and complete configuration.