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