Fast DB growing - Forum - OpenEdge RDBMS - Progress Community
 Forum

Fast DB growing

This question is answered

Hi all,

One of our partners tells us, that one database area is growing very fast. Is there a (more or less) easy way to find out, which table is growing? This would give us a hint, what’s going wrong in that installation.

We’re using OpenEdge 11.7.4 in mixed mode (64 bit DB / AppServer, 32 bit Client).

Apology for the possible beginner question, but I’m a developer and not so familiar with stuff like that.

Kind regards

Andreas

Verified Answer
  • The best way I can think of would be to do a dbanalys on that area.

    proutil [dbname] -C dbanalys area [areaname] -csoutput

    Then run it again in 24 hours or so, and compare the record counts to obtain a candidate list.

    More info on dbanalys is here: documentation.progress.com/.../index.html

    I'd make sure to run it out of normal business hours as it can have an impact on performance.

All Replies
  • The best way I can think of would be to do a dbanalys on that area.

    proutil [dbname] -C dbanalys area [areaname] -csoutput

    Then run it again in 24 hours or so, and compare the record counts to obtain a candidate list.

    More info on dbanalys is here: documentation.progress.com/.../index.html

    I'd make sure to run it out of normal business hours as it can have an impact on performance.

  • Great, that's what I'm looking for..

  • Since version 11.6 the best (the faster = instant) way is proutil db -C viewB2

  • This could be a case of a table that was added to an area intended for indexes.  If the area's RPB (records per block) setting is quite low, as is sometimes the case with index areas, then a table with a high rate of creates can lead to very fast growth of that area.  Another side-effect would be poor performance due to very sparsely-populated record blocks in that area.

    Have a look at the configuration of that area in the structure file (dbname.st).