Introduction
Monitors MSSQL data.
Discovery with the agent
Collector Type: Agent
Category: Application Monitors
Application Name: MSSQL2014
Global Template Name : Microsoft SQL 2014 DotNet v4 - Performance Counters
Pre-requisites : For MSSQL 2016 monitors need Microsoft .Net Framework 4.0.
Collected Metrics
| Metric Name | Display Name | Description | mssql2014.user.connections | mssql2014.user.connections | Shows the number of users connected to the system. |
|---|---|---|
| mssql2014.logins.per.sec | mssql2014.logins.per.sec | Shows the total number of logins started per second. |
| mssql2014.logouts.per.sec | mssql2014.logouts.per.sec | Shows the total number of logouts started per second. |
| mssql2014.sqlreceives.per.sec | mssql2014.sqlreceives.per.sec | Shows the number of SQL RECEIVE commands processed by the Broker per second. |
| mssql2014.sqlsends.per.sec | mssql2014.sqlsends.per.sec | Shows the number of SQL SEND commands processed by the Broker per second. |
| mssql2014.broker.transaction.rollbacks | mssql2014.broker.transaction.rollbacks | Shows the number of Service Broker related transactions that have rolled back. |
| mssql2014.tasklimit.reached | mssql2014.tasklimit.reached | Shows the total number of times the activated task limit on a queue has been reached. |
| mssql2014.tasksaborted.per.sec | mssql2014.tasksaborted.per.sec | Shows the number of activated tasks that are being aborted per second. |
| mssql2014.latchwaits.per.sec | mssql2014.latchwaits.per.sec | Shows the number of latch requests that could not be granted immediately and had to wait before being granted. |
| mssql2014.average.latchwait.timems | mssql2014.average.latchwait.timems | Shows the Average latch wait time (milliseconds) for latch requests that had to wait. |
| mssql2014.datafilessize.kb | mssql2014.datafilessize.kb | Shows the cumulative size of all the data files in the database. |
| mssql2014.logfiles.usedsize.kb | mssql2012.forwarded.records.per.sec | Shows the cumulative used size of all the log files in the database. |
| mssql2014.transactions.per.sec | mssql2014.transactions.per.sec | Shows the number of transactions started for the database. |
| mssql2014.locktimeouts.per.sec | mssql2014.locktimeouts.per.sec | Shows the number of lock requests that timed out. This includes requests for NOWAIT locks. |
| mssql2014.numberofdeadlocks.per.sec | mssql2014.numberofdeadlocks.per.sec | Shows the number of lock requests that resulted in a deadlock. |
| mssql2014.open.connection.count | mssql2014.open.connection.count | Shows the total number of transport connections currently open. |
| mssql2014.receiveiperos.per.sec | mssql2014.receiveiperos.per.sec | Shows the number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment. |
| mssql2014.sendiperos.per.sec | mssql2014.sendiperos.per.sec | Shows the number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment. |
| mssql2014.sqlcompilations.per.sec | mssql2014.sqlcompilations.per.sec | Shows the number of SQL compilations. |
| SQLReCompilationsPersec | SQLReCompilationsPersec | Shows the number of SQL recompiles. |
| mssql2014.sqlrecompilations.per.sec | mssql2014.sqlrecompilations.per.sec | Shows the ratio between cache hits and lookups. |
| mssql2014.cachehit.ratio | mssql2014.cachehit.ratio | Shows the Percentage of pages that were found in the buffer pool without having to incur a read from disk. |
| mssql2014.buffercache.hit.ratio | mssql2014.buffercache.hit.ratio | Percentage of pages that were found in the buffer pool without having to incur a read from disk. |