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

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

On the sybase-l mailing list,

Sybase

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

Comments

  1. Hi Jason,

    This is slightly off the topic of your post, but would you happen to know where I can find the Techwave presentations for 2006, 2007, 2008, and 2009? The official link to http://www.sybase.com/techwave/conference_content only contains presentations through 2005. No help from the forums at all.

    Thanks!

  2. 2008 – http://www.sybase.com/detail?id=1069518&siteId=1
    For 2009 & 2007, you need to get it from ISUG (http://my.isug.com). 🙁

  3. Gopal says:

    Hi Jason,

    How are you and very long time, hope you remember me , am your ex mate in UBS 🙂

    hope your doing good and i would like to access the below docs. please help me to get this, due have tried to click on the above link but i can’t get it 🙁

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

    cheers,
    Gopal

  4. IL WHAN SONG says:

    HI. Jason,

    I tried to find “Locking Redux – APL vs. DOL and Tuning ” Doc , I failed.

    If you have a copy of Doc , will you mail to me?

    1. I’ve asked Jeff for an updated location of the document

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Facebook login by WP-FB-AutoConnect