Online Documentation for SQL Manager for InterBase/Firebird

Database overview

The Database tab of Database Monitor allows you to get the general overview of the database.

The working area consists of the following sections:

Database parameters (database path, database ID, sweep interval, sweep active, sweep relation, sweep records, state, page reads, page writes, page fetches, page marks)

Transaction parameters (transactions, transaction commits, transaction rollbacks, transaction prepares, transaction deadlocks, transaction conflicts, transaction waits, next transaction, oldest interesting, oldest active, oldest snapshot, cache buffers, cache free writes, cache precedence, cache free waits, cache latch waits)

Objects (attachments, statements, pools, procedures, relations, triggers, active threads, allocated pages)

Memory (sort memory, current memory, maximum memory, permanent pool memory, cache pool memory)

Records (record selects, record inserts, record updates, record deletes, record purges, record expunges, record blackouts)