Files Repository
IBAnalyst is a tool, which helps to analyze InterBase or Firebird database statistics and to find problems with database performance, maintenance and application`s work.
Two main purposes of IBAnalyst are:
- Visualize database statistics
- Offer proven solutions and "how-to" to improve database performance based on resuly of automatic examination of database statistics.
Using IBAnalyst developer will be able to see in a few seconds all actual and potential problems with database: poor indices, fragmented tables, state of transactions, etc and get professional solutions how to solve these problems.
You know that InterBase has 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 some 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 colored 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.
- Main features of IBAnalyst are listed below:
- Retrieving database statistics via Service API and from gstat output.
- Summary of all actual and possible problems in database
- Colored grid representation of tables, indices and table->indices, which highlights fragmented tables, poor indices
- Automatic expertise of statistics