Post reply

Is update statistics logged?

  • October 22, 2010 at 11:48 am

    #143777

    Hi I'm getting ready to run a test but while I wait for the backup to transfer I thought I'd go ahead and as, is update statistics logged?

    i.e. will it cause the T-Log to grow?

  • October 22, 2010 at 12:56 pm

    #1241134

    It is logged, but is nowhere near the amount of logging that say a reindex does (even with fullscan).

  • October 22, 2010 at 1:12 pm

    #1241142

    UPDATE STATISTICS is a logged operation. However it should not make the transaction log to a huge size unless the table itself is too huge

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • October 22, 2010 at 1:32 pm

    #1241152

    Thanks, we had to forgo reindexing on this 14GB DB until we get more disk space, so I'm trying to avoid a disk space / tlog out of space error with the update statistics.

  • October 25, 2010 at 3:23 pm

    #1241965

    FYI, tempdb got hammered and grew quite a bit on my test server

Viewing 5 posts - 1 through 4 (of 4 total)

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