Post reply

Percentage Utilization of Log file

  • September 9, 2010 at 12:19 am

    #387749

    Hi All,

    I have a database of size 50GB and a log file of 10GB. When i queried the DBCC SQLPERF(LOGSPACE), I saw the % utilization to be less than 1%. Is it fine to shrink the log file to the bare minimum and expect some positives on the performance? there are no bulk transactions that happen in the database. I am just curious though i am not experiencing any difficulties at the moment.

    Thanks.

  • September 9, 2010 at 12:30 am

    #1218387

    If your log file has grown to 10 GB, there may be a reason. If you shrink it, you may find it growing again and this could result in fragmentation of the ldf file itself. If you are not hurting for disk space, I'd consider leaving it alone.

  • September 9, 2010 at 12:41 am

    #1218394

    Lyn Pettis, Thanks for your response. But the 10 GB size was reached over a period of time say few years. So i dont expect that to grow immediately. Again I am just being curious. 🙂

    THanks,

    Sudarsan

  • September 9, 2010 at 1:56 am

    #1218421

    Sudarsan Srinivasan (9/9/2010)

    Is it fine to shrink the log file to the bare minimum and expect some positives on the performance?

    No. A large log file (and yours is not large for the size of DB that you have) does not cause performance problems. Leave the log file alone, you'll likely need that size of log when you do index rebuilds.

    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 9, 2010 at 2:47 am

    #1218442

    Thank you Gail Shaw

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

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