Introduction
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.
Collected Metrics
| 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. |