Applications Systems

AppInsight Is Not Monitoring SQL Server Agent on Some Servers (SAM)

SQL Server Agent process is not monitored by Appinsight for SQL

First published date

11/8/2018 2:14 PM

Last published date

12/23/2025 4:36 PM

Overview

AppInsight for SQL has been enabled on the Settings > All Settings > SAM Settings > Manage Templates page in the Orion Web Console, but the SQL Server Agent process (SQLAGENT.EXE) is not being monitored on some database servers.

After being applied to a node either manually or via the Discovery Wizard , the AppInsight for SQL template becomes monitored as an application and multiple component monitors — including one for the SQL Server Agent — check the health of SQL server instances on the node.

If a component is enabled at the template level, it should also be enabled by default at the node level.

This works correctly when applying the template with the Discovery Wizard but not when applying AppInsight for SQL to a node manually via the Node Details view.

Product section

Server Application Monitor

Cause

The system does not correctly detect the SQL process name for the SQL Agent so it cannot define the SQL Server Instance name and template-level settings do not cascade down to the node-level settings as expected.

Resolution

Use the proper SQL instance name in the SQL Server Instance Name field when assigning AppInsight for SQL to the node on the Manage Template page.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.