Post reply

Estimating effect of transaction on log file size

  • August 24, 2004 at 4:30 am

    #102170

    Hi

    Does anyone know how to estimate the  effect of a transaction on the size of a transaction log file? We have some very large tables (in excess of 500 million rows) and I would like to have some idea of the effect on the size of the log file of an UPDATE query that effected all rows of one of these tables.

    Thanks in advance

  • August 24, 2004 at 9:05 am

    #520339

    It will grow alot!

    Not sure how to estimate this. Are you updating one field or many? At the least, it will have the old and new values and PK for each row.

  • August 24, 2004 at 10:05 am

    #520354

    Doing it in a single update probably not the best idea, better to run in chunks. Even if you know how much space you need for the log file it's a super large transaction, then you have to shrink the log later to reclaim space.

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply