|
|
|
IBAnalyst is a tool that assists a user to analyze in detail Firebird or InterBase database statistics and 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.
|
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.
Main features of IBAnalyst:
- Brings up to 30% performance boost if you follow all IBAnalyst recommendations!
- Retrieving database statistics via Service API and from gstat
output.
- Retrieving metadata of database to provide more detailed hints and recommendations.
- Summary of all actual and possible problems in database
- Coloured grid representation of tables, indices and table->indices,
which highlights fragmented tables, poor indices and so on.
- Automatic expertise of database statistics provides recommendations
and "how-to" solutions