Documentation forServer & Application Monitor

Add AppInsight for SQL to nodes

With the credentials and permissions configured on the target SQL server, you can easily add AppInsight for SQL to SQL servers through the Discovery Wizard or manually. An application monitor (also called an "application") is created for the node, based on the AppInsight for SQL template. In the Orion Web Console, the default name displayed for the application monitor is "MSSQLSERVER."

After AppInsight for SQL is assigned to a node, SAM polls 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 Monitor with AppInsight for SQL for details.

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

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 and follow the onscreen instructions.
  3. On the Applications panel, select the servers that you want to monitor. Only nodes with supported versions of Microsoft SQL appear.

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

    The Enter Credentials page appears.

  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.

  1. 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, specifying metrics, custom polling engines, and other options, as desired.
  5. Review and adjust any settings and click Add Node.
  6. Navigate to the All Applications widget and click your AppInsight for SQL application.

    The Enter Credentials page appears.

  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.

Apply AppInsight for SQL to an existing node

For existing nodes, you can add AppInsight for SQL to a node by assigning the AppInsight for SQL template to the node. See Assign templates to nodes manually to create application monitors.