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 NameDisplay NameDescription
MSSQL2016 User ConnectionsMSSQL2016 User ConnectionsShows the number of users connected to the system.
MSSQL2016 Logins Per SecMSSQL2016 Logins Per SecShows the total number of logins started per second.
MSSQL2016 Logouts Per SecMSSQL2016 Logouts Per SecShows the total number of logouts started per second.
MSSQL2016 SQL Receives Per SecMSSQL2016 SQL Receives Per SecShows the number of SQL RECEIVE commands processed by the Broker per second.
MSSQL2016 SQL Sends Per SecMSSQL2016 SQL Sends Per SecShows the number of SQL SEND commands processed by the Broker per second.
MSSQL2016 Broker Tranasaction Roll BacksMSSQL2016 Broker Tranasaction Roll BacksShows the number of Service Broker related transactions that have rolled back.
MSSQL2016 Task Limit ReachedMSSQL2016 Task Limit ReachedShows the total number of times the activated task limit on a queue has been reached.
MSSQL2016 Task Aborted Per SecMSSQL2016 Task Aborted Per SecShows the number of activated tasks that are being aborted per second.
MSSQL2016 Latch Waits Per SecMSSQL2016 Latch Waits Per SecShows the number of latch requests that could not be granted immediately and had to wait before being granted.
MSSQL2016 Average Latch Wait Time in MSMSSQL2016 Average Latch Wait Time in MSShows the Average latch wait time (milliseconds) for latch requests that had to wait.
MSSQL2016 Data Files Size KBMSSQL2016 Data Files Size KBShows the cumulative size of all the data files in the database.
MSSQL2016 Log Files Used Size KBMSSQL2016 Log Files Used Size KBShows the cumulative used size of all the log files in the database.
MSSQL2016 Transactions Per SecMSSQL2016 Transactions Per SecShows the number of transactions started for the database.
MSSQL2016 Lock Timeouts Per SecMSSQL2016 Lock Timeouts Per SecShows the number of lock requests that timed out. This includes requests for NOWAIT locks.
MSSQL2016 Number of Deadlocks Per SecMSSQL2016 Number of Deadlocks Per SecShows the number of lock requests that resulted in a deadlock.
MSSQL2016 Open Connection CountMSSQL2016 Open Connection CountShows the total number of transport connections currently open.
MSSQL2016 Receive IO Per SecMSSQL2016 Receive IO Per SecShows 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 SecMSSQL2016 Send IO Per SecShows 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 SecMSSQL2016 SQL Compilations Per SecShows the number of SQL compilations.
MSSQL2016 SQL ReCompilations Per SecMSSQL2016 SQL ReCompilations Per SecShows the number of SQL recompiles.
MSSQL2016 Cache Hit RatioMSSQL2016 Cache Hit RatioShows the ratio between cache hits and lookups.
MSSQL2016 Buffer Cache Hit RatioMSSQL2016 Buffer Cache Hit RatioShows the Percentage of pages that were found in the buffer pool without having to incur a read from disk.