troubleshooting Question

Configuring a RAID for clustering: One large array or many small arrays?

Avatar of SteveMBO
SteveMBO asked on
StorageServer HardwareMicrosoft SQL Server 2008
5 Comments1 Solution850 ViewsLast Modified:
The setup:

I have two servers and one RAID array.  I am building an active/active SQL 2008 cluster meaning that at all times there will be two instance of SQL running on this cluster.  In case of a server failure both instances of SQL Server will be running on the one remaining server.  

This means I need seven disk letters:
Two for data files
Two for log files
Two for tempdb.
One for quorum

2 x Dell R710 with Perc 5/e
1 x MD3000 w/ 15 x 136GB

The problem:
I am unsure which way to setup the disks for a two node active-active cluster.

1) Do I create one large 14-disk RAID 10 and then carve out the needed 7 drive letters?

2) Do I create 2 2-disk RAID 1 (Logs) and 2 5-disk RAID 5 (Data) then carve out the needed 7 drive letters? (The quorum and tempdb drives will be carved out of a log disk).

My concern with #1 is that both servers will be reading and writing to the same RAID 10 array and will bog it down.  What if server A is writing and server B is reading?  If they each get their own array then they won't compete-- theoretically.

Ideas?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros