Find problems
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.
Analyze statistics
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.
IBAnalyst is a tool to analyze InterBase or Firebird database statistics and find problems with database performance, maintenance and application's work.
Get recommendations
When statistics is loaded (from gstat output or Services API) you can view Summary, Table or Index information, or immediately take a look at Recommendations report. All suspicious objects or database header information items will be checked and reported: possible performance bottlenecks and how-to-fix recommendations.
Items being analyzed and reported:
- Database page size
- Forced write state
- Sweep interval
- Transactions information, including sweep gap, active transactions and transaction inventory page size
- Fragmented tables
- Deep indices
- Indices with bad selectivity (lot of key duplicates and with large groups of equal keys)
- Useless indices
- Tables with lot of record versions (tables being updated frequently)
- Massive updates/deletes
- Tables fragmented by blob data
- and more...
| 
