I was reading through the configuration settings recommended to us by our software vendor and I didn't understand the part below in quotes:
"Limit to one tempdb data file per processor". Set tempdb data files to 100
MB with 10 percent autogrowth in size.
I have quad dual core processors, does this mean i need 16 tempdb's? sounds crazy, but how do I control this and where on SQL server 2005?
Background, Server 2003 Enterprise R2 32-Bit, SQL 2005 Standard