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