You are here: Database Administration > Managing Database Operations > Monitoring Database Operation > Useful SQL Metrics Related to Database Operation

Useful SQL Metrics Related to Database Operation

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

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 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 Published by Database Processes.