Monitors MSSQL data.
Discovery with the agent
Collector Type: Agent
Category: Application Monitors
Application Name: MSSQL2008
Global Template Name : Microsoft SQL 2008 DotNet v4 - Performance Counters
Pre-requisites : For MSSQL 2008 monitors need Microsoft .Net Framework 4.0.
|Number of users connected to the system.
|Total number of logins started per second.
|Total number of logouts started per second.
|The number of SQL RECEIVE commands processed by the Broker per second.
|The number of SQL SEND commands processed by the Broker per second.
|The number of Service Broker related transactions that have rolled back.
|The total number of times the activated task limit on a queue has been reached.
|The number of activated tasks that are being aborted per second.
|Number of latch requests that could not be granted immediately and had to wait before being granted.
|Average latch wait time (milliseconds) for latch requests that had to wait.
|The cumulative size of all the data files in the database.
|The cumulative used size of all the log files in the database.
|Number of transactions started for the database.
|Number of lock requests that timed out. This includes requests for NOWAIT locks.
|Number of lock requests that resulted in a deadlock.
|The total number of transport connections currently open.
|The number of transport receives I/O per second. Note that a transport receive I/O may contain more than one message fragment.
|The number of transport send I/Os per second. Note that a transport send I/O may contain more than one message fragment.
|Number of SQL compilations.
|Number of SQL recompiles.
|Ratio between cache hits and lookups.
|Percentage of pages that were found in the buffer pool without having to incur a read from disk.