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.