SQL Server

What is a tempDB in SQL Server?

Sai5 pointsBadges:

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...

SQL Server Ask the Experts2,585 pointsBadges:

Adding files to TempDB

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

SQL Server Ask the Experts2,585 pointsBadges:

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...

SQL Server Ask the Experts2,585 pointsBadges:

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?

SQL Server Ask the Experts2,585 pointsBadges: