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 NameDisplay NameDescription
mssql.serverworkqueue.queuelengthMSSQL ServerWorkQueueQueueLengthCurrent 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.secMemory PagesPerSecPages/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.lengthLogicalDisk AverageDiskReadQueueLengthAvg. 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.lengthLogicalDisk AverageDiskWriteQueueLengthAvg. Disk Write Queue Length is the average number of write requests that were queued for the selected disk during the sample interval.