Post reply

How can we reduce the temp db size, if it exceeds its normal size

  • January 7, 2008 at 3:27 am

    #119599

    if temp db exceeds more than its normal size, what are the ways to reduces its size.

  • January 13, 2008 at 11:08 pm

    #767564

    Pl. refer the following microsoft link:

    http://support.microsoft.com/kb/307487

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • January 15, 2008 at 8:07 pm

    #768441

    Try:

    DBCC SHRINKDATABASE('yourDB')

  • January 15, 2008 at 9:09 pm

    #768453

    Hi

    thanx

  • January 16, 2008 at 1:20 am

    #768490

    TempDB grows if there's lots of temp table usage, or queries that need internal work tables. It's alos sometimes used byt th query processor for sorts and aggregates.

    If your tempDB keeps growing to a certain size, personally I'd recommend that you change the TempDB file sizes so that it starts at that size.

    There are no issues (other than disk space) with a large TempDB.

    You can shrink it, but it's likely it will just grow again.

    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 5 posts - 1 through 5 (of 5 total)

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