How to avoid most reorgs of DOL tables in Sybase ASE (Jeff Tallman)

On the sybase-l mailing list,


Jeff Tallman replied to a question on how to avoid unnecessary reorgs. He graciously agreed to let me post his response here 🙂

You can avoid most (if not all) of the reorgs by doing:

  1. setting the exp_row_size to something that covers about 90% of the space each row takes up
  2. changing enable housekeeper GC to a 4 or 5

Both of these are a *MUST* do for DOL (datapages or datarows). See manuals on ‘enable housekeeper GC’ for correct setting of 4 or 5 (refers to whether deletes are batch or OLTP).

You can also watch for housekeeper overflows in monEngine/monOpenObjectActivity……and if you see any HKGC pending – wait a few before shutting down.

Jeff wrote up an excellent article, Locking Redux – APL vs. DOL and Tuning, that goes into detail why this is the case.

Share Button

Letting a Troll disrupt your day.. Don’t feed the troll!

Over on the sybase-l mailing list, IDo Not Feed the Troll let a troll cloud my good sense for a few minutes.  As an ISUG board member and a member of TeamSybase and as an adult, I must not allow myself to be baited so.  Please forgive me for losing my cool.

All in all, I’ve had a better weekend than Jeff Simmermon over at andiamnotlying.compouring espresso on ice is a bad thing according to some coffee shops.  *shakes head*

Share Button