Introduction
Monitors MSSQL data.
Discovery with the agent
Collector Type: Agent
Category: Application Monitors
Application Name: MSSQL_2012_Advanced_Monitoring
Global Template Name : Microsoft SQL 2012 Advanced Performance Counters DotNet v4
Pre-requisites : For MSSQL 2012 monitors need Microsoft .Net Framework 4.0.
Collected Metrics
| Metric Name | Display Name | Description |
|---|---|---|
| mssql.active.transactions | mssql.active.transactions | Shows number of active update transactions for the database. |
| mssql.transactions.per.sec | mssql.transactions.per.sec | Shows number of transactions started for the database. |
| mssql.page.life.expectancy | mssql.page.life.expectancy | Shows the number of seconds a page will stay in the buffer pool without references. |
| mssql.average.wait.timems | mssql.average.wait.timems | Shows the average amount of wait time (in milliseconds) for each lock request that resulted in a wait. |
| mssqldb.allocated.freespace.mb | mssqldb.allocated.freespace.mb | Shows the allocated freespace for memory manager. |
| mssql.db.cpu.utilization | mssql.db.cpu.utilization | Shows the percentage of CPU utilization for sql db. |
| mssql.stolen.server.memorykb | mssql.stolen.server.memorykb | Shows the amount of memory the server is currently using for the purposes other than the database pages. |