Firebird Database Dashboard | Sinatica Monitor

Firebird Database Introduction: Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.

In short, it is a Free – Open Source Database

Sinatica‘s application monitors your database in real-time and finds out what is happening with your Firebird server. Observing your server’s activity patterns, you can take actions to stop problems before they strike.

Here are some important metrics that anyone using Firebird should be monitoring

I/O Activity Chart
– Measures Disk read and write I/O, as well as cache I/O. This allows DBAs to easily spot points in time where the disk subsystem may have been the database bottleneck.

Transaction Activity Chart
– Especially important for Firebird databases, shows if database sweep is happening normally and if all transactions ran smoothly.

Leading I/O Consumers Chart
– This pie chart displays the top four I/O consumers in the last __ minutes. DBAs may select to view consumers as client processes, client addresses or database users.

Database Objects Chart
– The number of allocated statements, transactions and attachments presented in this chart are useful as a rough estimate of server load. Users may also click on these lines to view the allocated objects at a certain point in time.

Image

 

 

 

 

 

 

 

 

 

 

 

 

Image

 

 

 

 

 

 

 

 

 

 

 

 

There are very few Database monitoring dash-boards and this dashboard for Firebird should really become a good handy tool for DBAs and Developers.

Comments are closed.