Post reply

Tempdb size

  • March 31, 2006 at 2:25 am

    #111603

    Hi,

    is there an way, where i can calculate a useful size of the tempdb, when i restrict the tempdb size?

    Or an other question - Could it happen that the sql-server bedomes a problem with a too small size of the tempdb, when the size is restricted (for example 3 GB)?

    Thanks in advance for your help and kind regards from Austria

  • April 3, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • April 3, 2006 at 8:58 am

    #630436

    Since tempdb is used for scratch space for worktables, ordering, groups, etc. it's size really depends on the queries and loads that you throw at it. There's no good tool to size it and you need to see what's appropriate for your system by tracking the size and then setting a minimum size.

    If you restrict it's growth, then you can cause problems for applications that run out of temp space needed. The server will continue to run, but queries will fail.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • April 6, 2006 at 1:59 am

    #631145

    Thank you for your answer

    Jürgen Gleiß

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

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