IBAnalyst

BAnalyst is a tool that allows a database administrator to analyze detailed Firebird or InterBase database statistics and then identify possible problems with database performance, maintenance and how an application interacts with the database. It graphically displays database statistics and can then automatically make intelligent suggestions about improving database performance and database maintenance.

Product Properties

The main purpose of IBAnalyst is to provide you with a visual display of your database statistics, and then offer valuable advice on how to to improve database performance based on the examination of database statistics.

By using this tool, a database administrator can to see in a few seconds all the actual and potential problems that might exist in a database, for example poor indices, fragmented tables, transaction states, etc and then get valuable and knowledgeable solutions how to solve these problems

You know that InterBase has a special tool to gather database statistics - gstat. It is a command line tool which provides large amount of statistical information about database inside. Statistics is represented in a text view and developer needs to spend a lot of time to retrieve useful information from gstat output.

But retrieving the useful information is not enough – developer needs to make decisions based on this information, and it is not easy to understand the actual meaning of all these values.

If you ever try to get statistics of your database and understand what all this stuff means, you will appreciate the features of IBAnalyst.

First, IBAnalyst visualizes database statistics – you can easily navigate through all your tables, indices and their relationships and view their states, with smart hints and coloured representation of problem objects.

Second, IBAnalyst makes decisions for you! The powerful analytic module is embedded into IBAnalyst. It automatically analyzes all gathered statistics and generates the recommendations and "how-to" solutions.