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 Name | Display Name | Description |
|---|---|---|
| mssql2019.latchwaitspersec | MSSQL2019 LatchWaitsPersec | Shows the number of latch requests that could not be granted immediately and had to wait before being granted. |
| mssql2019.averagelatchwaittimems | MSSQL2019 AverageLatchWaitTimems | Shows the Average latch wait time (milliseconds) for latch requests that had to wait. |
| mssql2019.datafilesizekb | MSSQL2019 DataFilesSizeKB | Shows the cumulative size of all the data files in the database. |
| mssql2019.logfilesusedsizekb | MSSQL2019 LogFilesUsedSizeKB | Shows the cumulative used size of all the log files in the database. |
| mssql2019.locktimeoutspersec | MSSQL2019 LockTimeoutsPersec | Shows the number of lock requests that timed out. This includes requests for NOWAIT locks. |
| mssql2019.numberofdeadlockspersec | MSSQL2019 NumberofDeadlocksPersec | Shows the number of lock requests that resulted in a deadlock. |
| mssql2019.buffercachehitratio | MSSQL2019 Buffercachehitratio | Shows the Percentage of pages that were found in the buffer pool without having to incur a read from disk. |
| mssql2019.pagelifeexpectancy | MSSQL2019 Pagelifeexpectancy | Number of seconds a page will stay in the buffer pool without references. |
| mssql2019.physicaldisk.avgdisksecperread | MSSQL2019 PhysicalDisk AvgDisksecPerRead | Avg. Disk sec/Read is the average time, in seconds, of a read of data from the disk. |
| mssql2019.physicaldisk.avgdisksecperwrite | MSSQL2019 PhysicalDisk AvgDisksecPerWrite | Avg. Disk sec/Write is the average time, in seconds, of a write of data to the disk. |