Useful SQL Metrics Related to Database Operation

The following metrics are of particular interest for monitoring database operation:

Metric Name Description

Metric Name	Description
SqlListenerSqlProcTime	Time spent processing SQL messages, in milliseconds, since the last time metrics were provided. Processing time starts from the point a message is received from an application client, includes all the time needed to process the message, and ends when a response is sent back to the client.
SqlListenerIdleTime	Time in milliseconds since the last time metrics were provided that this Transaction Engine (TE) was waiting for a message from an application client.
SqlListenerStallTIme	Time in milliseconds since the last time metrics were provided that the process is waiting for something to happen, including time blocked, objects to load, network waits and locks. This time is included in the `SqlListenerSqlProcTime` metric.
Commits	Number of transaction commits since the last time metrics were provided.
Rollbacks	Number of transaction rollbacks since the last time metrics were provided.
Inserts	Number of records inserted since the last time metrics were provided.
Updates	Number of records updated since the last time metrics were provided.
Deletes	Number of records deleted since the last time metrics were provided.

SqlListenerSqlProcTime

Time spent processing SQL messages, in milliseconds, since the last time metrics were provided. Processing time starts from the point a message is received from an application client, includes all the time needed to process the message, and ends when a response is sent back to the client.

SqlListenerIdleTime

Time in milliseconds since the last time metrics were provided that this Transaction Engine (TE) was waiting for a message from an application client.

SqlListenerStallTIme

Time in milliseconds since the last time metrics were provided that the process is waiting for something to happen, including time blocked, objects to load, network waits and locks. This time is included in the SqlListenerSqlProcTime metric.

Commits

Number of transaction commits since the last time metrics were provided.

Rollbacks

Number of transaction rollbacks since the last time metrics were provided.

Inserts

Number of records inserted since the last time metrics were provided.

Updates

Number of records updated since the last time metrics were provided.

Deletes

Number of records deleted since the last time metrics were provided.

For information about additional metrics, see Metrics.