DCMDiagnostics​.Global attributes

CmdDataSetUpdateCount

Total number of dataset updates executed since last reset.

CmdDataSetUpdateCountFail

Total number of failed dataset updates executed since last reset.

CmdDataSetUpdateCountSuccess

Total number of successful dataset updates executed since last reset.

CmdExecuteAvgDuration

Average length of time (in milliseconds) a command takes to execute.

CmdExecuteLastDuration

Length of time (in milliseconds) it took for the last command to execute.

CmdExecuteLastTime

Date and time of last command executed.

CmdExecuteMaxDuration

Maximum length of time (in milliseconds) a command took to execute.

CmdNonQueryCount

Total number of non-query commands executed since last reset.

CmdNonQueryCountFail

Total number of failed non-query commands executed since last reset.

CmdNonQueryCountSuccess

Total number of successful non-query commands executed since last reset.

CmdQueryCount

Total number of query commands executed since last reset.

CmdQueryCountFail

Total number of failed query commands executed since last reset.

CmdQueryCountSuccess

Total number of successful query commands executed since last reset.

CmdQueuedAvgDuration

Average length of time (in milliseconds) a command spent in the DCM queue.

CmdQueuedLastDuration

Length of time (in milliseconds) the last command spend in the DCM queue.

CmdQueuedMaxDuration

Maximum length of time (in milliseconds) a command spent in the queue.

ConnectionAvgDuration

Average length of time a connection is open.

ConnectionCount

Total number of attempted connections since last reset.

ConnectionCountFail

Total number of failed connections since last reset.

ConnectionCountSuccess

Total number of successful connections since last reset.

ConnectionCurrentActiveCount

Number of currently active connections

ConnectionMaxDuration

Max length of time a connection is open.

DCMStartTime

Start time of the DCM.

DCMVersion

The DCM assembly version.

OraclePoolActivePoolCount

The number of active pools (one pool per unique login within a pool group).

OraclePoolActivePoolGroupCount

The number of active pool groups (one group per unique connection string).

OraclePoolExecutingConnectionCount

The number of connections currently awaiting completion and therefore unavailable for use.

OraclePoolHardConnectCountPerSecond

The number of hard connections per second that are being made to a database server.

OraclePoolHardDisconnectCountPerSecond

The number of hard disconnects per second that are being made to a database server.

OraclePoolInactivePoolCount

The number of inactive pools pending cleanup.

OraclePoolInactivePoolGroupCount

The number of inactive pool groups pending cleanup.

OraclePoolNonPooledConnectionCount

The number of active connections that are not pooled.

OraclePoolPooledConnectionCount

The number of active connections that are pooled.

OraclePoolReclaimedConnectionCount

The number of connections that have been reclaimed through garbage collection.

Note: Not explicitly closing or disposing connections degrades performance.

QueueCurCount

Current number of entries in queue.

QueueMaxCount

Maximum number of entries in the queue since last reset.

ResetCmd

Resets diagnostics information.

At runtime, this attribute calls the DCM reset command for diagnostics.

SqlPoolActivePoolCount

The number of active pools. There is one pool per unique login within a pool group.

SqlPoolActivePoolGroupCount

The number of active pool groups. There is one group per unique connection string.

SqlPoolExecutingConnectionCount

The number of connections currently awaiting completion and therefore unavailable for use.

SqlPoolHardConnectCountPerSecond

The number of hard connections per second that are being made to a database server.

SqlPoolHardDisconnectCountPerSecond

The number of hard disconnects per second that are being made to a database server.

SqlPoolInactivePoolCount

The number of inactive pools pending cleanup.

SqlPoolInactivePoolGroupCount

The number of inactive pool groups pending cleanup.

SqlPoolNonPooledConnectionCount

The number of active connections that are not pooled.

SqlPoolPooledConnectionCount

The number of active connections that are pooled.

SqlPoolReclaimedConnectionCount

The number of connections that have been reclaimed through garbage collection.

Note: Not explicitly closing or disposing connections degrades performance.

TransCount

Total number of transactions executed since last reset.

TransCountFail

Total number of failed transactions executed since last reset.

TransCountSuccess

Total number of successful transactions executed since last reset.

TransExecuteAvgDuration

Average length of time a (in milliseconds) needed for transaction to execute.

TransExecuteLastDuration

Length of time (in milliseconds) needed by the DCM to execute the last transaction.

TransExecuteLastTime

Date and time the last transaction was executed

TransExecuteMaxDuration

Maximum length of time (in milliseconds) a transaction has taken to execute.

TransQueuedAvgDuration

Average length of time a (in milliseconds) a transaction spent in the queue.

TransQueuedLastDuration

Length of time (in milliseconds) the last transaction spent in the DCM queue.

TransQueuedMaxDuration

Maximum length of time (in milliseconds) a transaction has spent in the queue.