troubleshooting Question

tempdb data file per processor

Avatar of ValleyENT
ValleyENT asked on
Microsoft SQL Server 2005Windows Server 2003
8 Comments1 Solution506 ViewsLast Modified:
Hello All,
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
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros