Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 TempDb

Author  Topic 

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2007-03-10 : 09:20:25
Hi Experts,

Whats is the best Disk raid for TempDB? Will the performance of the database will go slow if I move it to a slower disk like RAID 5 with 5000 RPM?

Thanks in Advance
Sachin


Don't sit back because of failure. It will come back to check if you still available. -- Binu

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2007-03-12 : 10:07:46
RAID 10 is best. on RAID5, it will definitely be slower especially with 5000RPM.
Its been a while since I have seen 5000RPM except on a laptop. Usually servers are 10k or 15k RPM
Go to Top of Page
   

- Advertisement -