Post reply

virtual log file size

  • January 24, 2012 at 4:28 pm

    #267201

    I have a database that had over 40,000 VLFs. Following advice from here I was able to shrink the file to where it "should" be. The log shrunk to 256MB with 8 VLFs of roughly 32MBs each which is probably how it was created. I expanded the log to 2GB (I measured "normal" usage to be about 1.6GB) and now have 24 VLFs (8 at 32MBs and 16 at 112MBs), which all makes sense.

    My question: is it problematic to have the VLFs at differing sizes?

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.

  • January 24, 2012 at 4:49 pm

    #1438021

    No.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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