Post reply

Transaction Log space required by individual transaction

  • July 11, 2017 at 5:41 am

    #331792

    Is it possible to estimate, even if only very approximately, how much transaction log space a given transaction is likely to take?

    For example, if I delete a million rows from a table as a single transaction, would it be reasonable to assume that the transaction log space required for this would be roughly equivalent to the size of the deleted rows x 1.5 (allowing an additional 0.5 of space for rollback).

  • July 11, 2017 at 5:51 am

    #1950344

    Yes, I would say about the size of the data that's being deleted.  But try it for yourself on a system that doesn't have anything else happening on it, and then you'll know for sure.

    John

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

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