Re: SAN drive config for SQL Cluster

From: Kamal Hassan (Hassan_at_discussions.microsoft.com)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 09:17:01 -0800

I also have a question for Uttam Parui...

I plan to install 2 node cluster (initially) and then add third and may be
fourth node later.

I plan to do the following:

3 luns (SQL Data for each NODE1 i.e Server1, Server2, Server3) = E, F, G
3 luns (2 SQL log shared by S1, S2, S3, 1 for Quorum) = S, T, Q

Each Server has following:

C:\ (mirrrored) = OS
D:\ (mirrored) = SQL Binary + PAGE FILE

Server1 (Node1/Active)
Data=E:\
Log=S:\
Quorum=Q:\

Server2 (Node2/Passive)
Data=E:\
Log=S:\
Quorum:Q:\

Server3 (To be added later as an ACTIVE Node with Server 2 as PASSIVE/StandBy)
Data=F:\
Log=T:\
Quorum=Q:\

First, I am not sure if this is correct for 3/4 four nodes cluster and if it
is how it will work/affect FAILOVER when it happens between S1 & S2 or S3 & S2

I would greatly appreciate if you can provide any feedback.

Regards,

Kamal

"Uttam Parui[MS]" wrote:

> Use RAID 5 on read-only volumes. Any disk volume that does more than 10 percent writes is not a good candidate for RAID 5.
> Use RAID 10 whenever the array experiences more than 10 percent writes.
>
> In general, for OLTP systems, RAID 10 is the best for data + logs.
>
> Regarding the original qs - as many have already answered --- have seperate luns for Quorum, msdtc, sql data, sql Tlogs, SQL backups etc. One huge lun is not recommended for high availability.
>
> Best Regards,
>
> Uttam Parui
> Microsoft Corporation
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
>
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
>