SQL Server Performance

Cluster Help!!!

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by sachinsamuel, Jul 20, 2007.

  1. sachinsamuel New Member

    Hi All,

    Can I use a single shared drive to configure 2 cluster of Oracle and SQL server?

    Let me explain my question a little but.

    1) I have 2 Servers attached to a SAN box configured on Cluster (Active-Passive).
    2) I have installed SQL and Oracle servers on each Server attached to the SAN box.
    3) Lets say SQL server fails on Server A but Oracle is still working fine on Server A, Will there be a Failover?

    Thanks in Advance
    Sachin
  2. bradmcgehee New Member

    SQL Server and Oracle clustering are completely different and are not compatible. If your SAN be be divided up so that the applications are physically independent of each other, then you should be able to run each cluster separately and independently. But if your SAN is small and you are not able to divide the drives so they are separate, then you can't use it to support both types of clustering.

    --------------------------------------------------------------
    Brad M. McGehee, SQL Server MVP
    Technical Editor/Moderator www.SQL-Server-Performance.Com
    Director of DBA Education for www.Red-Gate.Com
    www.sqlbrad.com
    www.sqlHawaii.com
  3. satya Moderator

    ... also this will not be supported by MS PSS as clustering policies are very specific to use only SQL in thsi case.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page