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 NameDisplay NameDescription
mssql2017.latchwaitspersecMSSQL2017 LatchWaitsPersecShows the number of latch requests that could not be granted immediately and had to wait before being granted.
mssql2017.averagelatchwaittimemsMSSQL2017 AverageLatchWaitTimemsShows the Average latch wait time (milliseconds) for latch requests that had to wait.
mssql2017.datafilesizekbMSSQL2017 DataFilesSizeKBShows the cumulative size of all the data files in the database.
mssql2017.logfilesusedsizekbMSSQL2017 LogFilesUsedSizeKBShows the cumulative used size of all the log files in the database.
mssql2017.locktimeoutspersecMSSQL2017 LockTimeoutsPersecShows the number of lock requests that timed out. This includes requests for NOWAIT locks.
mssql2017.numberofdeadlockspersecMSSQL2017 NumberofDeadlocksPersecShows the number of lock requests that resulted in a deadlock.
mssql2017.buffercachehitratioMSSQL2017 BuffercachehitratioShows the Percentage of pages that were found in the buffer pool without having to incur a read from disk.
mssql2017.pagelifeexpectancyMSSQL2017 PagelifeexpectancyNumber of seconds a page will stay in the buffer pool without references.
mssql2017.physicaldisk.avgdisksecperreadMSSQL2017 PhysicalDisk AvgDisksecPerReadAvg. Disk sec/Read is the average time, in seconds, of a read of data from the disk.
mssql2017.physicaldisk.avgdisksecperwriteMSSQL2017 PhysicalDisk AvgDisksecPerWriteAvg. Disk sec/Write is the average time, in seconds, of a write of data to the disk.