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.
[quoted text, click to view] >-----Original Message-----
>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.
[quoted text, click to view] >
>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)
[quoted text, click to view] >
>Is this a good configuration with the limited resource?
Can this fit for Active/Active mode for SQL binary
failover?
[quoted text, click to view] >
>Thanks a lot.
>.
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
[quoted text, click to view] >-----Original Message-----
>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.
[quoted text, click to view] >
>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)
[quoted text, click to view] >
>Is this a good configuration with the limited resource?
Can this fit for Active/Active mode for SQL binary
failover?
[quoted text, click to view] >
>Thanks a lot.
>.
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)
[quoted text, click to view] "Linchi Shea" <linchi_shea@NOSPAMml.com> wrote in message news:<0d1901c3dac1$aee89fd0$a501280a@phx.gbl>...
> 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
>
> >-----Original Message-----
> >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.
> >.
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.
[quoted text, click to view] >-----Original Message-----
>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.
[quoted text, click to view] >
>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)
[quoted text, click to view] >
>Is this a good configuration with the limited resource?
Can this fit for Active/Active mode for SQL binary
failover?
[quoted text, click to view] >
>Thanks a lot.
>.
Don't see what you're looking for? Try a search.
