regarding sql server clusters RRS feed

  • Question

  • Hi,

    We are looking at building a medium farm topology.which has 2 front ends, one app, onededicated search and one sql server. I was suggesting having sql server clusters.What does it mean

    when one says a sql server is clustered?( is it  similar concept to  the having 2 web front end with load balancing) i.e the 2 sql server cluster maintain the same data and for performance either one of them is choosen or we create 2 nodes for one sql server?

    Apprecite your help!



    • Moved by Mike Walsh FIN Thursday, July 14, 2011 3:43 PM admin q (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Thursday, July 14, 2011 2:34 PM


  • It is a similar concept to load balancing, but requires more specific hardware and is a bit more complex to setup.  Normally for SharePoint you setup an Active Passive SQL cluster, where you have two SQL servers that share a set of disk drives between them.  Then if one server fails the other picks up and serves as the SQL server for the environment until you can fix the first SQL server.  Its for fault tolerance and won't help with performance issues.

    Load Balancing on web front ends serves both to increase capacity (performance) and provide fault tolerance.

    Paul Stork SharePoint Server MVP
    • Marked as answer by spcrawler Friday, July 15, 2011 2:10 PM
    Thursday, July 14, 2011 3:56 PM