Monitors MSSQL data.
Discovery with the agent
Collector Type: Agent
Category: Application Monitors
Application Name: MSSQL2019
Global Template Name : Microsoft SQL 2019 DotNet v4
Pre-requisites : For MSSQL monitors need Microsoft .Net Framework 4.0.
|Shows the number of latch requests that could not be granted immediately and had to wait before being granted.
|Shows the Average latch wait time (milliseconds) for latch requests that had to wait.
|Shows the cumulative size of all the data files in the database.
|Shows the cumulative used size of all the log files in the database.
|Shows the number of lock requests that timed out. This includes requests for NOWAIT locks.
|Shows the number of lock requests that resulted in a deadlock.
|Shows the Percentage of pages that were found in the buffer pool without having to incur a read from disk.
|Number of seconds a page will stay in the buffer pool without references.
|MSSQL2019 PhysicalDisk AvgDisksecPerRead
|Avg. Disk sec/Read is the average time, in seconds, of a read of data from the disk.
|MSSQL2019 PhysicalDisk AvgDisksecPerWrite
|Avg. Disk sec/Write is the average time, in seconds, of a write of data to the disk.