Introduction
Monitors MSSQL data.
Discovery with the agent
Collector Type: Agent
Category: Application Monitors
Application Name: mssql2012_wmi
Global Template Name : Microsoft SQL Server 2017 DotNet v4 - Performance Counters
Pre-requisites : For MSSQL 2012 monitors need Microsoft .Net Framework 4.0.
Collected Metrics
| Metric Name | Display Name | Description |
|---|---|---|
| mssql2017.latchwaitspersec | MSSQL2017 LatchWaitsPersec | Shows the number of latch requests that could not be granted immediately and had to wait before being granted. |
| mssql2017.averagelatchwaittimems | MSSQL2017 AverageLatchWaitTimems | Shows the Average latch wait time (milliseconds) for latch requests that had to wait. |
| mssql2017.datafilesizekb | MSSQL2017 DataFilesSizeKB | Shows the cumulative size of all the data files in the database. |
| mssql2017.logfilesusedsizekb | MSSQL2017 LogFilesUsedSizeKB | Shows the cumulative used size of all the log files in the database. |
| mssql2017.locktimeoutspersec | MSSQL2017 LockTimeoutsPersec | Shows the number of lock requests that timed out. This includes requests for NOWAIT locks. |
| mssql2017.numberofdeadlockspersec | MSSQL2017 NumberofDeadlocksPersec | Shows the number of lock requests that resulted in a deadlock. |
| mssql2017.buffercachehitratio | MSSQL2017 Buffercachehitratio | Shows the Percentage of pages that were found in the buffer pool without having to incur a read from disk. |
| mssql2017.pagelifeexpectancy | MSSQL2017 Pagelifeexpectancy | Number of seconds a page will stay in the buffer pool without references. |
| mssql2017.physicaldisk.avgdisksecperread | MSSQL2017 PhysicalDisk AvgDisksecPerRead | Avg. Disk sec/Read is the average time, in seconds, of a read of data from the disk. |
| mssql2017.physicaldisk.avgdisksecperwrite | MSSQL2017 PhysicalDisk AvgDisksecPerWrite | Avg. Disk sec/Write is the average time, in seconds, of a write of data to the disk. |