DBE insert

Table engine row inserts per second.

This counter is for DataBase Engine (DBE) inserts and applies to both disk-based and in-memory tables. It is incremented when an insert to a table occurs.

DBE delete

Table engine row deletes per second.

This counter is for DataBase Engine deletes and applies to both disk-based and in-memory tables. It is incremented when a delete to a table occurs.

DBE update

Table engine row updates per second.

This counter is for DataBase Engine updates and applies to both disk-based and in-memory tables. It is incremented when an update to a table occurs.

DBE fetch

Number of rows that are fetched per second, which might or might not be returned to the application

High numbers relative to SQL fetch can indicate unnecessary table scans.

Compare this counter to SQL fetch to see how many rows are being read internally for each row that is returned to the application (ratio of rows read to rows returned). If that ratio is high, you might have unnecessary table scans occurring and should investigate index usage.

DBE fetch M-table

Number of rows fetched from in-memory tables

DBE fetch D-table

Number of rows fetched from disk-based tables

DBE dd operation

Number of data dictionary operations that the server has executed.

The data dictionary (or system catalog) stores all the definitions for tables, indexes, and so forth. This number should correlate to the expected number of data dictionary changes.