Increasing TEMPdb files

• MASSIMILIANO_DONATI

  SSC Rookie

  Points: 48

  More actions

  February 25, 2010 at 2:29 am

  #216014

  Hi,

  I'd like to submit you the following question. I am a newbie of SQL Server 2008 and need now to increase the size of tempdb files, linking one specific tempdb file for each processor. I have specifically 8 processor (2 processors in a quad core configuration). Please advise me on which procedure i should follow to achieve this result.

  My SQL configuration is an active passive node cluster configurations with three instances.

  Thank you in advance,

  Max

• sturner

  SSC-Insane

  Points: 22411

  More actions

  February 25, 2010 at 12:47 pm

  #1125171

  look up ALTER DATABASE in BOL it should explain how you can do it.

  Alternatively, you can right click on tempdb from SMC, go to "files/filegroups" and do it that way.

  The probability of survival is inversely proportional to the angle of arrival.