Post reply

Dealing with a large tempdb log file

  • July 20, 2012 at 10:57 am

    #98557

    Hi All,

    I have a 2000 SP4 failover cluster, vendor provided database system.

    Tempdb mdf is 4.5 GBs, the log file is 29 GBs.

    Am I correct in thinking that a restart will bring tempdb done to its initial configured size but that it is quite likely that whatever caused the log file to grow (assuming it was not a one time event) will likely happen again and the log will revert back to its current size.

    juts looking for a little backup so I can tell the SAN guys to hand over the storage space....

    thanks

  • July 20, 2012 at 10:58 am

    #1515659

    Chrissy321 (7/20/2012)

    Am I correct in thinking that a restart will bring tempdb done to its initial configured size but that it is quite likely that whatever caused the log file to grow (assuming it was not a one time event) will likely happen again and the log will revert back to its current size.

    Yes and yes. You'll need to hunt down the root cause to resolve permanently

    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