Hide this message
Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.
Identify performance and troubleshoot issues for SQL databases and queries with AppInsight for SQL. This feature provides consolidated resource views into over 100 performance 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. Through one page, monitor resource consumption, respond to alerts, and monitor expensive queries without digging through multiple pages and views.
Investigate issues and performance trends without hunting through numerous views into the SQL servers in your environment. AppInsight for SQL provides a level of detail and expert knowledge far beyond what a SQL template can provide, allowing you to monitor virtually every aspect of your SQL instances and databases. The feature polls and reports metrics without use of agents, directly accessing the SQL server using configured access permissions and credentials using SNMP and WMI.
See AppInsight for SQL requirements and permissions for requirements.
To add a node and configure AppInsight for SQL, see the following:
When applied to a Microsoft SQL instance, the AppInsight for SQL page replaces the default node details page. It monitors as an application using multiple component monitors the AppInsight for SQL template. To modify the template or use other templates, see Edit the AppInsight for SQL template.
The views are accessible through one of the following:
The SQL Server Application Summary provides resources to monitor overall data for all SQL servers including alerts, events, consumed resources:
Further expanding the All Applications on the SQL Server Application Summary displays a quick view into performance counters and status. Each counter and metric can be expanded to review data.
To view all information for an application node, select the application from the view to open the details page for the AppInsight for SQL node. For example, MSSQLSERVER on lab-dem-sql-02.demo.lab in the Orion demo encountered a critical alert. To troubleshoot, access the SQL server through the All Applications resource.
This view consolidates all specific data for the selected SQL server:
To review database data, inthe AppInsight for SQL Details view, locate and select a database in the All Databases resource. The database details view includes details, a list of all databases on the node, alerts, AppStack, and more.
To see performance counter details, in the AppInsight for SQL Details view, locate and select a performance counter in any resource.