FB TraceManager 2 - Documentation

Database Monitoring - Header Page Monitoring

Database Monitoring - Header Page Monitoring

Previous topic Next topic  

Database Monitoring - Header Page Monitoring

Previous topic Next topic  

The Header Page Monitoring facility queries the database header page, which allows you to inspect important base settings like forced writes, page size, page buffers etc. of your database.

 

To start header page monitoring for the connected database, click the Start button and make sure that the Paused option isn't checked.

 

 

Raw Output

 

The raw output is identical to running gstat -h <database> on the command-line. For example:

 

fbtm_hpm_raw_output

 

 

Parsed Output

 

Additionally, FB TraceManager parses the output and adds the result of each header page fetch request into a grid with capabilities to filter, sort data and apply aggregations in the grid footer per-column.

 

fbtm_hpm_parsed_output

 

This makes it easy to read and furthermore, FB TraceManager also provides "derived" attributes, like the gaps/differences between the various transaction counters as shown above in the OIT_AT, OIT_OST, OIT_NT, OAT_OST, OAT_NT and OST_NT columns. A customizable color management facility, with meaningful default-settings, underlines suspicious database settings (e.g. Forced Writes = OFF etc.).

 

 

Parsed Output Storage

 

If you wish, the parsed output can be persisted in the FBTM2.fdb database in a table called HEADER_PAGE_DATA_PARSED. This allows you to query/inspect header page data at a later point in time. To enable parsed output storage, you have to select the Log to database option in the Settings flyout tool panel. A Commit Interval defines the number of records when a database commit should happen. With a click on the Commit Now button, you immediately can persist the uncommitted parsed output records in the FBTM2.fdb database.

 

 

Customization and Settings

 

The header page monitoring module is highly customizable. Simply click the Settings flyout tool panel to get in touch with various options.

 

fbtm_hpm_settings

 

The various settings are more or less self-explanatory. Use the Notify Only When Changed option if you wish that not each header page fetch request is visualized automatically, independent on whether the header page has changed or not. There is a similar setting Log Only When Changed available, which is used for parsed output storage.

 

The user-definable colors on various header page data gives you a way to spot questionable conditions more easily.

 

Changed settings are stored and re-loaded every time you open the database monitoring area when connecting to a database.

 

 

See also

Register Project

Database Monitoring

Database Monitoring - Monitoring (MON$) Tables

 

 

Database Monitoring

Database Monitoring - Monitoring (MON$) Tables