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
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
What is a tempDB in SQL Server?
Answer Question | July 19, 2008 8:50 AM
SQL Server 2005, TempDBs, Visual Studio 2005, Windows XP
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
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