2 mirrored drives or 6 smaller RAID 10 drives???

• Marysa

  Ten Centuries

  Points: 1023

  More actions

  February 24, 2005 at 11:25 am

  #109624

  What would be better performance wise for a 4GB SQL 2000 database....

  2x146GB mirrored that would contain the DB datafiles

  or

  6x36GB RAID 10 that would contain the DB datafiles

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  February 24, 2005 at 5:53 pm

  #544055

  RAID 10 is the best option for your data files. A mirrored volume can give you better performance for the log files if you have the flexibility of having both configuration.

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  February 25, 2005 at 3:24 am

  #544104

  I/O wize perfer the 6*.... but also provide the chanels ! or you may encounter chanel-queues.

  

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• Marysa

  Ten Centuries

  Points: 1023

  More actions

  February 25, 2005 at 3:26 am

  #544105

  what about 4x36GB raid 10? or is that just a waste?

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 25, 2005 at 7:07 am

  #544144

  Please don't multi-post. Keep this thread in one place. Either here or http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=163847

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]