Adding files to TempDB
Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?

Answer Question   |  March 11, 2010  6:41 PM
SQL, SQL Server 2005, TempDBs

How many tempdb’s necessary in our clustered environment?
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 [...]

Answer Question   |  March 9, 2009  6:18 PM
Clustered servers, SQL Server clustering, TempDBs

SQL Server
What is a tempDB in SQL Server?

Answer Question   |  July 19, 2008  8:50 AM
SQL Server 2005, TempDBs, Visual Studio 2005, Windows XP

Slowdown of the SAN due to overusage of temporary tables
We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. [...]

Answer Question   |  July 30, 2008  8:23 PM
iSCSI, RAID 10, SAN, SQL stored procedures, Stored Procedures, TempDBs

Building and locating multiple TempDBs for SQL Server
When building multiple TempDBs for a SQL Server that has multiple CPUs, should each TempDB (tempdev, tempdev1) data file reside on its own physical drive? Can all the tempdev data files reside on the same physical drive?

Answer Question   |  June 23, 2008  7:28 PM
SQL Server, TempDBs, Tempdev