SQL Server
What is a tempDB in SQL Server?
View Answer
| Jul 18 2008 8:50 AM GMT
| asked by
Sai
Windows XP, Visual Studio 2005, SQL Server 2005
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...
View Answer
| Jul 1 2008 8:23 PM GMT
| asked by
SQL Server Ask the Experts
SAN, Stored procedures, SQL stored procedures
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?
View Answer
| Jun 23 2008 7:28 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, TempDBs, Tempdev
