TempDB per processor, does autogrow keep proportional fill from working

• SQLBalls

  SSCarpal Tunnel

  Points: 4621

  More actions

  June 10, 2010 at 1:23 pm

  #222637

  Hi All,

  I'm setting up a new server for a new application and the vendor has asked that the tempdb be optimized. I've created one datafile per processor and have them at equivalent size to allow proportianl fill.

  However I saw a topic in the 2005 forum that said allowing autogrow to be on these files could keep proportional fill from working.

  http://www.sqlservercentral.com/Forums/Topic636220-146-1.aspx

  The MSDN article on optimizing TempDB does not mention this downfall

  http://msdn.microsoft.com/en-us/library/ms175527.aspx and actually recommends that you leave the db on auto grow, which is my perference.

  But I was curious if anyone has had experience with this in 2008.

  Twitter: @SQLBalls
  Blog: http://www.SQLBalls.com
  Channel: https://www.youtube.com/@Tales-from-the-Field

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  June 10, 2010 at 2:36 pm

  #1178927

  Although I can't speak directly to 2008 I know that it was a problem in 2005. I'd probably set the sizes and disable auto-grow.

  CEWII