SQL Server Performance

Active/Active/Passive Cluster

Discussion in 'SQL Server 2005 Clustering' started by si1981, Jun 22, 2007.

  1. si1981 New Member

    I've been doing a lot of reading on clustering and would just like someone to confirm that I'm understanding all this correctly.

    The company I work for have a database application and also want to implement MS Sharepoint.

    Am I right in saying that I can have three nodes:
    one with a SQL instance to run the db app.
    one with a SQL instance to run sharepoint.
    And finally, a third node to act as failover for both of these apps, effectivly giving me an N+1 configuration?

    Thanks in advance for any help.
  2. Raulie New Member

    This sounds right.

    Raulie



  3. Raulie New Member

    This sounds right.

    Raulie



  4. satya Moderator

    On the second one you have to see whether Sharepoint will work with automatic failover, as SQL server can.
    THis could be a problem in relying the automated high availability solution.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.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.
  5. si1981 New Member

    Does that still apply if we have a sharepoint farm i.e. seperate front end web servers/app servers etc so that the only part of Sharepoint that's in the cluster is the database?

    Simon
  6. satya Moderator

    I think it should work, I'm not sure but its better to check with Sharepoint (Office) related forums or articles in this case, we have had such issues in the past using Sharepoint & SQL within the clustered environment.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.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