SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion

MIS2007 is really going good. There are many things going on. As I mentioned in my previous article, It is really pleasure to meet industry leaders. There was discussion about what is good for database RAID 5 configuration or RAID 10. This subject is always very interesting.

We were discussing from small databases (5GB) to larger databases(5 TB). The question was which RAID 5 or RAID 10. Surprisingly, everybody who participated in discussion said their experience says RAID 10 is better for this particular application as there are lots of reads and writes in database. One of the expert suggested that they have seen performance improvement of more than 6 times for RAID 10. One expert expressed that though they prefer RAID 10 but their IT department suggest RAID 5. The reason was RAID 10 is very expensive over RAID 5 with 6 TB database.

Overall, we all agreed on RAID 10 without any discussion. Please consult your IT department and run few performance test before implementation.

There was very good key note address by Roger Dow, President and CEO, Travel Industry Association. It was very interesting and motivation note. He addressed the issue “There is no such thing as customer loyalty in an intensely competitive world. Customers are changing and we must change to satisfy their individual needs.” Read More: SQL SERVER – Raid Configuration – RAID 10

Reference : Pinal Dave (https://blog.sqlauthority.com)

,
Previous Post
SQL SERVER – Index Optimization CheckList
Next Post
SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.

Related Posts

1 Comment. Leave new

  • John M Cider
    May 9, 2007 10:19 pm

    Dave,
    I wish I have met you. I was there in the conference. It was wonderful. What produt does your company use. We really want to implement Plan and e-message. Let us see how it goes. We left Las Vegas at noon and I just started to read my feed and I found that you were there too.
    Any way, next year at orleans right?

    Reply

Leave a Reply Cancel reply

Exit mobile version