Introduction

InterBase version 7 introduced several database monitoring features, including:

•Connection Monitoring

•Statement Monitoring

•Performance Monitoring

•Memory Monitoring

Any InterBase 7 database (On Disk Structure 11) offers a set of temporary system tables with information about connections, statements, transaction and much more. Database Workbench wraps these system tables and creates a couple of very useful screens for you to monitor your database activity without the need to create complex SQL statements yourself.

Automatic Refresh

All these monitoring screens use an automatic refresh (interval configurable) by using multiple threads. The InterBase 7 client library is thread-safe, previous versions aren't. So only use these features if you have the v7 client installed.