Introduction
Monitors MSSQL data.
Discovery with the agent
Collector Type: Agent
Category: Application Monitors
Application Name: MSSQL2012PerformanceCounters
Global Template Name : Microsoft SQL 2012 DotNet v4 - Performance Counters
Pre-requisites : For MSSQL 2012 monitors need Microsoft .Net Framework 4.0.
Collected Metrics
| Metric Name | Display Name | Description | mssql2012.free.list.stalls.per.sec | mssql2012.free.list.stalls.per.sec | Shows number of active update transactions for the database. |
|---|---|---|
| mssql2012.page.reads.per.sec | mssql2012.page.reads.per.sec | Number of physical database page reads issued. |
| mssql2012.page.writes.per.sec | mssql2012.page.writes.per.sec | Number of physical database page writes issued. |
| mssql2012.database.pages | mssql2012.database.pages | Number of pages in the buffer pool with database content. |
| mssql2012.cache.object.counts | mssql2012.cache.object.counts | Number of cache objects in the cache. |
| mssql2012.cache.objects.in.use | mssql2012.cache.objects.in.use | Number of cache objects in use. |
| mssql2012.target.server.memory.kb | mssql2012.target.server.memory.kb | Ideal amount of memory the server is willing to consume. |
| mssql2012.granted.workspace.memory.kb | mssql2012.granted.workspace.memory.kb | Total amount of memory granted to executing processes. This memory is used for hash, sort and create index operations. |
| mssql2012.auto.param.attempts.per.sec | mssql2012.auto.param.attempts.per.sec | Number of autoparameterization attempts. |
| mssql2012.failed.auto.params.per.sec | mssql2012.failed.auto.params.per.sec | Number of failed autoparameterizations. |
| mssql2012.batch.requests.per.sec | mssql2012.batch.requests.per.sec | Number of SQL batch requests received by server. |
| mssql2012.forwarded.records.per.sec | mssql2012.forwarded.records.per.sec | Number of records fetched through forwarded record pointers. |
| mssql2012.page.splits.per.sec | mssql2012.page.splits.per.sec | Number of page splits per second that occur as a result of overflowing index pages. |
| mssql2012.full.scans.per.sec | mssql2012.full.scans.per.sec | Number of unrestricted full scans. These can either be base table or full index scans. |
| mssql2012.probe.scans.per.sec | mssql2012.probe.scans.per.sec | Number of probe scans per second that are used to find at most one single qualified row in an index or base table directly. |
| mssql2012.range.scans.per.sec | mssql2012.range.scans.per.sec | Number of qualified range scans through indexes per second. |
| mssql2012.workfiles.created.per.sec | mssql2012.workfiles.created.per.sec | Number of work files created per second. For example, work files could be used to store temporary results for hash joins and hash aggregates. |
| mssql2012.worktables.created.per.sec | mssql2012.worktables.created.per.sec | Number of work tables created per second. For example, work tables could be used to store temporary results for query spool, LOB variables, XML variables, and cursors. |
| mssql2012.lock.requests.per.sec | mssql2012.page.splits.per.sec | Number of new locks and lock conversions requested from the lock manager. |
| mssql2012.lock.wait.time.ms | mssql2012.lock.wait.time.ms | Total wait time (milliseconds) for locks in the last second. |