We are planning a new SQL cluster. We intend to have the two servers separated by 100 meters. Will the cluster's shared disk array be a single point of failure for us?
So in a sense, the shared disk array is a single point of failure should the entire array fail. But if the shared array is well designed and employs fault tolerance features, it should be very reliable. This is a good reason why you should not skimp on spending money on a shared disk array for a SQL Server database cluster.
If you intend to separate the two nodes of the cluster by 100 meters, you will have no choice but to use Fibre Channel connections to the shared array, as SCSI is not supported for such a long distance.]]>