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 move the tempdb, and perhaps the logs, off the SAN?
July 1, 2008 8:23 PM
July 30, 2008 6:42 PM