How many tempdb’s necessary in our clustered environment?
Home > IT Answers > SQL Server > How many tempdb's necessary in our clustered ...
SQL Server Ask the Experts
2445 pts.
0
Q:
How many tempdb's necessary in our clustered environment?
TempDBs, Clustered servers, SQL Server clustering
We have a clustered environment with three nodes and five instances. Each node has eight CPU's, and we are wondering how many tempdb's are necessary for each instance. Do you do the calculation on the total number of CPU's, all 5 instances failed over to one node or some other variation that I should be considering?
ASKED: Mar 9 2009  6:18 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46765 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Each instance of SQL Server has its own tempdb database.

Each tempdb database should have one file for each CPU core that it will be using.

If each node has 8 CPU cores then each tempdb should be setup with 8 files.
Last Answered: Mar 9 2009  9:04 PM GMT by Mrdenny   46765 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0