Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

tempdb data file per processor

Avatar of ValleyENT
ValleyENT asked on
Windows Server 2003Microsoft SQL Server 2005
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