Monitoring Database Performance
Go Up to IBConsole: The InterBase Interface
You can use the IBConsole performance monitor to view the status and activities of a database, including:
- A summary of database threads, procedures, transactions and memory use.
- View memory use by graph, pool or heap.
- List all the tables and views in the database.
- Display a list of all recent transactions.
- View a list of all recent procedures and triggers.
- Display the interbase log file and statistics list.
Displaying the Performance Monitor
To display the performance monitor:
- 1. In the left pane, right-click on a database name, and select Performance Monitor from the context menu. The Performance Monitor appears.
- 2. The Performance Monitor contains the following tabs: Attachments, Database, Memory, Procedures, Statements, Tables & Views, Transactions, and Triggers. Click on a tab to view the information displayed on that tab.
- The picture below displays the Database tab. Notice the options (Flush Write Cache, Reclaim Memory Space and others) that appear above the tab name. You can click on an option to perform that action on the database. Each tab contains different options.
