Introduction
Monitors MSSQL data.
Discovery with the agent
Collector Type: Agent
Category: Application Monitors
Application Name: MSSQL2016
Global Template Name : Microsoft SQL Server 2016 DotNet v4 - Performance Counters
Pre-requisites : For MSSQL 2016 monitors need Microsoft .Net Framework 4.0.
Collected Metrics
| Metric Name | Display Name | Description |
|---|---|---|
| MSSQL2016 User Connections | MSSQL2016 User Connections | Shows the number of users connected to the system. |
| MSSQL2016 Logins Per Sec | MSSQL2016 Logins Per Sec | Shows the total number of logins started per second. |
| MSSQL2016 Logouts Per Sec | MSSQL2016 Logouts Per Sec | Shows the total number of logouts started per second. |
| MSSQL2016 SQL Receives Per Sec | MSSQL2016 SQL Receives Per Sec | Shows the number of SQL RECEIVE commands processed by the Broker per second. |
| MSSQL2016 SQL Sends Per Sec | MSSQL2016 SQL Sends Per Sec | Shows the number of SQL SEND commands processed by the Broker per second. |
| MSSQL2016 Broker Tranasaction Roll Backs | MSSQL2016 Broker Tranasaction Roll Backs | Shows the number of Service Broker related transactions that have rolled back. |
| MSSQL2016 Task Limit Reached | MSSQL2016 Task Limit Reached | Shows the total number of times the activated task limit on a queue has been reached. |
| MSSQL2016 Task Aborted Per Sec | MSSQL2016 Task Aborted Per Sec | Shows the number of activated tasks that are being aborted per second. |
| MSSQL2016 Latch Waits Per Sec | MSSQL2016 Latch Waits Per Sec | Shows the number of latch requests that could not be granted immediately and had to wait before being granted. |
| MSSQL2016 Average Latch Wait Time in MS | MSSQL2016 Average Latch Wait Time in MS | Shows the Average latch wait time (milliseconds) for latch requests that had to wait. |
| MSSQL2016 Data Files Size KB | MSSQL2016 Data Files Size KB | Shows the cumulative size of all the data files in the database. |
| MSSQL2016 Log Files Used Size KB | MSSQL2016 Log Files Used Size KB | Shows the cumulative used size of all the log files in the database. |
| MSSQL2016 Transactions Per Sec | MSSQL2016 Transactions Per Sec | Shows the number of transactions started for the database. |
| MSSQL2016 Lock Timeouts Per Sec | MSSQL2016 Lock Timeouts Per Sec | Shows the number of lock requests that timed out. This includes requests for NOWAIT locks. |
| MSSQL2016 Number of Deadlocks Per Sec | MSSQL2016 Number of Deadlocks Per Sec | Shows the number of lock requests that resulted in a deadlock. |
| MSSQL2016 Open Connection Count | MSSQL2016 Open Connection Count | Shows the total number of transport connections currently open. |
| MSSQL2016 Receive IO Per Sec | MSSQL2016 Receive IO 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. |
| MSSQL2016 Send IO Per Sec | MSSQL2016 Send IO Per Sec | Shows the number of transport send I/O per second. Note that a transport send I/O may contain more than one message fragment. |
| MSSQL2016 SQL Compilations Per Sec | MSSQL2016 SQL Compilations Per Sec | Shows the number of SQL compilations. |
| MSSQL2016 SQL ReCompilations Per Sec | MSSQL2016 SQL ReCompilations Per Sec | Shows the number of SQL recompiles. |
| MSSQL2016 Cache Hit Ratio | MSSQL2016 Cache Hit Ratio | Shows the ratio between cache hits and lookups. |
| MSSQL2016 Buffer Cache Hit Ratio | MSSQL2016 Buffer Cache Hit Ratio | Shows the Percentage of pages that were found in the buffer pool without having to incur a read from disk. |