-
What is a tempDB in SQL Server?
Last updated: -
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. Should we...
Last updated: -
Do I need to restart SQL Server 2005, if I have added additional files to the TempDB?
Last updated: -
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...
Last updated: -
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?
Last updated: