Good SQL Server hardware ?

• isuckatsql

  SSChampion

  Points: 10381

  More actions

  October 6, 2011 at 3:51 am

  #1391113

  So for TempDb is Raid1 ok, or are you suggesting something else?

• sturner

  SSC-Insane

  Points: 22411

  More actions

  October 6, 2011 at 6:57 am

  #1391181

  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.

• mendesm

  Ten Centuries

  Points: 1074

  More actions

  October 6, 2011 at 9:31 am

  #1391272

  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.