Monitors MSSQL data.
Discovery with the agent
Collector Type: Agent
Category: Application Monitors
Application Name: MSSQLPerformanceCounters
Global Template Name : Microsoft SQL 2019 DotNet v4
Pre-requisites : For MSSQL monitors need Microsoft .Net Framework 4.0.
|Metric Name||Display Name||Description|
|mssql.serverworkqueue.queuelength||MSSQL ServerWorkQueueQueueLength||Current length of the server work queue for this CPU. A sustained queue length greater than four might indicate processor congestion. This is an instantaneous count, not an average over time.|
|memory.pages.per.sec||Memory PagesPerSec||Pages/sec is the rate at which pages are read from or written to disk to resolve hard page faults. This counter is a primary indicator of the kinds of faults that cause systemwide delays. It is the sum of Memory\\Pages Input/sec and Memory\\Pages Output.|
|logicaldisk.average.disk.read.queue.length||LogicalDisk AverageDiskReadQueueLength||Avg. Disk Read Queue Length is the average number of read requests that were queued for the selected disk during the sample interval.|
|logicaldisk.average.disk.write.queue.length||LogicalDisk AverageDiskWriteQueueLength||Avg. Disk Write Queue Length is the average number of write requests that were queued for the selected disk during the sample interval.|