MS SQL Server Clustering - Re: Defunct Drives Issue

Author

Re: Defunct Drives Issue

Geoff N. Hiten

2005-03-31, 8:03 pm

Looks like there is a problem sharing a controller between the clustered
resource and the local disk resources. Make the vendor show you where this
is a certified cluster solution. I don't thing shared controllers is
supported.

Any way you slice it, you will get very poor performance from a SCSI storage
array in a clustered environment using RAID5 containers. Clustering
requires that the controllers operate in direct-write mode (no write cache)
so RAID5 is extremely slow.

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator

"Joel" < joelmacaluso@hotmail
.com> wrote in message
news:Of$K0BHNFHA.244@tk2msftngp13.phx.gbl...
> Thanks Geoff,
>
> Here's what I think you are looking for:
>
> 1.)Both servers are equipped with 2x18GB (Array A) mirrored. They are
> connected to the internal channel of the IBM4MX SCSI. This is the logical
> C: and D: drives.
> The external Channel 1 of the Raid controller connects to the shared scsi.
>
> 2.)Array B = 2x18 GB mirrored = Q drive (Quorum) slots 13-14. (Physical
> device is a shared IBM SCSI storage array)
>
> 3)Array C= 5x18 Raid 5 = S drive (Shared) slots 0-4 (Physical device is
> shared IBM SCSI storage array)
>
> Summarized:
>
> LUNs= Q: and S: [Storage Array-Arrays B&C]
>
> C: and D: internal Server [Array A]
>
>
> "Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
> news:uiCzd1ANFHA.2136@TK2MSFTNGP14.phx.gbl...
>
>

R P

2005-04-12, 11:25 am

Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.clustering:17788

This looks identical in concept to HP prepackaged cluster setup that I am
using in an extremely similar fashion (Internal Mirrors are C: only). Have
not have any problems similar to that in 7 months of running.

"Geoff N. Hiten" <sqlcraftsman@gmail.com> wrote in message
news:ezGgdnfNFHA.3512@TK2MSFTNGP15.phx.gbl...
> Looks like there is a problem sharing a controller between the clustered
> resource and the local disk resources. Make the vendor show you where
this
> is a certified cluster solution. I don't thing shared controllers is
> supported.
>
> Any way you slice it, you will get very poor performance from a SCSI
storage
> array in a clustered environment using RAID5 containers. Clustering
> requires that the controllers operate in direct-write mode (no write
cache)
> so RAID5 is extremely slow.
>
>
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
>
> "Joel" < joelmacaluso@hotmail
.com> wrote in message
> news:Of$K0BHNFHA.244@tk2msftngp13.phx.gbl...
logical[color=darkre
d]
scsi.[color=darkred]
give[color=darkred]
your[color=darkred]
has[color=darkred]
may[color=darkred]
where[color=darkred]

while[color=darkred]

>
>

Sponsored Links