October 6, 2011 at 3:51 am
So for TempDb is Raid1 ok, or are you suggesting something else?
October 6, 2011 at 6:57 am
isuckatsql (10/6/2011)
So for TempDb is Raid1 ok, or are you suggesting something else?
Yes. We use RAID 1 for tempdb on most our servers, the rest have RAID10 for size and performance reasons. We actually have had a drive failure on this array on one of our servers. It was simple hot swap out with no downtime.
If your systems are 24/7 like most of us, I would bet even money that the failure will occur at 2AM in the morning... you will be glad you had a redundant array on tempdb.:-D
The probability of survival is inversely proportional to the angle of arrival.
October 6, 2011 at 9:31 am
sturner (10/6/2011)
isuckatsql (10/6/2011)
So for TempDb is Raid1 ok, or are you suggesting something else?Yes. We use RAID 1 for tempdb on most our servers, the rest have RAID10 for size and performance reasons. We actually have had a drive failure on this array on one of our servers. It was simple hot swap out with no downtime.
If your systems are 24/7 like most of us, I would bet even money that the failure will occur at 2AM in the morning... you will be glad you had a redundant array on tempdb.:-D
And depending on the system, it could turn out that you can even put tempdb in a raid5 array. See the recurring theme here? => It depends on the system.
Viewing 3 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply