Documentation forServer & Application Monitor

Monitor with AppInsight for SQL

Identify performance and troubleshoot issues for SQL databases and queries with AppInsight for SQL, a feature that provides visibility into over 100 metrics across all SQL servers monitored by SAM. These metrics include 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.

With AppInsight for SQL, you can monitor resource consumption, respond to alerts, and monitor expensive queries on a single page. Investigate issues and performance trends without hunting through numerous views for SQL servers. AppInsight for SQL provides a level of detail far beyond what a SQL template can provide, allowing you to monitor virtually every aspect of your SQL instances and databases. It can poll and report metrics without using agents, directly accessing SQL servers using configured access permissions and credentials via SNMP and WMI.

To get started with AppInsight for SQL:

When you assign AppInsight for SQL to a node, an application (also called an "application monitor") based on the AppInsight for SQL template is created on the node. In the Orion Web Console, the default name for the application is "MSSQLSERVER" but can be customized.

When SAM begins polling for SQL metrics, the standard Node Details view is replaced by the SQL Server Application Summary view, accessible by clicking My Dashboards > Applications > SQL Server. This view shows all SQL server instances monitored by AppInsight for SQL. From here, you can click an instance to open its Application Details view. For more ways to view data, see Display AppInsight for SQL data in the Orion Web Console

Learn more

To learn more about AppInsight for SQL, see:

Additional learning resources include: