20.3. Database Read/Write Activity Report

The following database read/write activity is graphically represented by each of the bar charts on the EnterpriseDB DBA Management Server landing page:

• Transactions: The Transactions bar chart shows the number of transactions (TX) committed and rolled back by user operations.

• Memory Reads: The Memory Reads bar chart displays the amount of cache blocks hit.

• Disk Reads: The Disk Reads bar chart displays the physical disk blocks read by the user operations.

Apart from all the database read/write activity, the home page also contains a table summarizing the following information on each row for each configured datasource:

• Database - Database name in the format hostname:port/database

• Version - The database's major and minor version number

• Owner - The name of the database owner

• DB Size - Size of the database using KB, MB, GB or TB as appropriate

• Active Sessions - The number of active sessions

• Server Uptime - The number of active sessions

• Query Logging - Shows if Query Logging is currently ON or OFF for a configured datasource. The entire row is displayed in red if Query Logging is ON, or black if Query Logging is OFF. For more details on enabling/disabling Query Logging via DBA Management Server please refer to Query Profiler

The DB Size and Server Uptime columns are only available with EnterpriseDB and PostgreSQL versions 8.1 and above.

This report can be refreshed by pressing the button.

If a server is not available, the tab for that server will appear "Grey" with a red cross on it. The tab will be un-selectable as shown in the following screenshot:

When multiple data sources are configured, every data source is assigned a separate color value in order to differentiate each data source from each other.

If a data source is not available for some reason or one of the connection parameters defined in the configure.xml file is incorrect, an appropriate error message is displayed.