Commands (SAP DB) 

The following is found in the Database Monitor and provides you with an overview of SQL statement components.

Table: Commands

Command Type

Command Function

SQL command

Number of statements sent to the database for processing. This is a direct indicator of database activity.

Rollbacks

Indicate unsuccessful database actions, usually as a result of a terminated application.

Commits

Indicate successful database actions.

Prepares

Number of dynamic SQL statements

Executes

Number of dynamic SQL statements executed

The ratio of rollbacks to commits can indicate logical inconsistencies in one or more SQL statements.

See also:

Performance Database