Introduction

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.

Collected Metrics

<
Metric NameDisplay NameDescription
mssql2019.latchwaitspersecMSSQL2019 LatchWaitsPersecShows the number of latch requests that could not be granted immediately and had to wait before being granted.
mssql2019.averagelatchwaittimemsMSSQL2019 AverageLatchWaitTimemsShows the Average latch wait time (milliseconds) for latch requests that had to wait.
mssql2019.datafilesizekbMSSQL2019 DataFilesSizeKBShows the cumulative size of all the data files in the database.
mssql2019.logfilesusedsizekbMSSQL2019 LogFilesUsedSizeKBShows the cumulative used size of all the log files in the database.
mssql2019.locktimeoutspersecMSSQL2019 LockTimeoutsPersecShows the number of lock requests that timed out. This includes requests for NOWAIT locks.
mssql2019.numberofdeadlockspersecMSSQL2019 NumberofDeadlocksPersecShows the number of lock requests that resulted in a deadlock.
mssql2019.buffercachehitratioMSSQL2019 BuffercachehitratioShows the Percentage of pages that were found in the buffer pool without having to incur a read from disk.
mssql2019.pagelifeexpectancyMSSQL2019 PagelifeexpectancyNumber of seconds a page will stay in the buffer pool without references.
mssql2019.physicaldisk.avgdisksecperreadMSSQL2019 PhysicalDisk AvgDisksecPerReadAvg. Disk sec/Read is the average time, in seconds, of a read of data from the disk.
mssql2019.physicaldisk.avgdisksecperwriteMSSQL2019 PhysicalDisk AvgDisksecPerWriteAvg. Disk sec/Write is the average time, in seconds, of a write of data to the disk.