I got two hard disks (36GB each) on each of two SQL Servers and one Storage Area Network (SAN) as 73GB x 8. We would like to install SQL Cluster in Active / Active mode

Here is my current proposed configuration. Can someone please provide a better configuration if possible

The two hard disk in both SQL servers are RAID1 (mirror)
The eight hard disk in the SAN are in one LUM and partitioned into 5 partitions (1G as Quorum + Log for SQL1 + Data for SQL1 + Log for SQL2 + Data for SQL2

Is this a good configuration with the limited resource? Can this fit for Active/Active mode for SQL binary failover

Thanks a lot.

Good question - I have the same issues and would like to
add a related question if I may:
Our SAN engineer suggests that since SAN's are already
very resilient we may as well put the data and logs onto
the same drive letter (all on one RAID) for each instance.
This adds the advantage that I do not have to worry about
how to split the space between logs and data. Also, it
makes it easier for the SAN to dynamically "move" drives
to performance hot-spots. However, this goes against db
best practices as I have always kept the data and logs
seperate in the past.
Cheers, Rob.

would like to install SQL Cluster in Active / Active mode.
+ Data for SQL1 + Log for SQL2 + Data for SQL2)
failover?

A SAN LUN is typically presented to Windows as a single
SCSI disk (note that Fibre Channel storage devices adhere
to the SCSI protocol). At least, that's how it works in
our enviornments and I don't know whether it's even
possible to present a LUN to a Windows host as
two 'physical' disks to create two disk resources. You do
need two separate shared disks to have an active\active or
two-instance cluster. Typically, you need to get two LUNs
from the SAN for that.

Linchi

would like to install SQL Cluster in Active / Active mode.
+ Data for SQL1 + Log for SQL2 + Data for SQL2)
failover?

Another solution is to use a diffrent but yet supported Polyserve MxDB
for SQL. Based on a clustered File System Technology, It will enable
you to use the same disk (s) for both nodes.

Tomer Meshorer
Database Engineering
Polyserve Inc (http://www.polyserve.com/sql)


"Linchi Shea" <linchi_shea (AT) NOSPAMml (DOT) com> wrote

Yes that would do as A/A. One need to create two cluster
group one per each SQL Server and assign a data and log
to each.

We would like to install SQL Cluster in Active / Active
mode.
SQL1 + Data for SQL1 + Log for SQL2 + Data for SQL2)
failover?