SQL Server Performance

TemPDB

Discussion in 'SQL Server 2005 General DBA Questions' started by Joben, May 20, 2010.

  1. Joben New Member

    Hi,
    I need to do the following in my Production Server. Can somebody please share their experience or please give me some tips on how to do it.
    4. Setup a maintenance plan to truncate the tempdb as needed to control the size.
  2. Luis Martin Moderator

    Welcome to the forums!
    Interview?. Home work?
  3. FrankKalis Moderator

    Apart from Luis' answer, if tempDB grows in size, SQL Server apparently needs the space. So why not size tempDB properly plus some buffer and then in the meantime see if you can reduce tempDB usage by reviewing some code? There is little sense in shrinking the size when it's foreseeable that it will grow again.
  4. Luis Martin Moderator

    What happens with all original question with 1), 2) and 3)?
  5. satya Moderator

Share This Page