Post reply

High VLF count

  • September 26, 2014 at 3:06 am

    #299685

    Hi

    We are currently loading data into our databases via a DMT. The databases are using simple recovery model and have just recently been created. I have noted that there are a lot of vlf's in the transaction log. On one database the log file looks like it has been set at 24mb , the auto grow set to 'by 10 percent, Unlimited'. The current size of that log file is 23.81mb with 70 vlfs.

    Another db has log file size of 45mb with 33 vlf's

    Would this affect the performance of the database in regards to dataloads ?

  • September 26, 2014 at 3:12 am

    #1748403

    Loads, no.

    VLFs affect things which read the log. Restores, database recovery, that kind of thing.

    The 10% growth is the problem here. You should have fixed intervals for growth, not %.

    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

  • September 26, 2014 at 3:19 am

    #1748405

    Yeah I was going to change that 'grow by 10%' setting to something like 'by 250Mb' and size the log at a more reasonable size. I haven't set these db's up and certainly wouldn't have chosen that setting.

    Thanks Gail

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

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