SQL Server Performance

Real Application cluster

Discussion in 'SQL Server 2008 General DBA Questions' started by ismailadar, May 3, 2011.

  1. ismailadar New Member

    Hi all,
    I have searched about with real application clustering in SQL Server latest version. In oracle there is a feature named RAC. and it provides high availability and Load Balancing together. I wonder how can i achive this (RAC feature in oracle) using SQL Server? coz SQL server uses windows clustering service and windows clustering service only provides high availability.
    Tnanks in advance
    ismailadar, May 3, 2011
    #2

  2. satya Moderator

    Is this a generic comparison you want to know or something planned in your organisation?
    If you hover through the search engines there are multiple posts talking about pros and cons. In a nutshell what the application needs is scalability and load balancing in ther terms of RAC. There are valueable HA features avalable in SQL Server that will satisfy their HA / DR needs.
    The recovery of data depends on how the database is designed to handle the trnsactions and HA features http://www.microsoft.com/sql/technologies/highavailability/default.mspx and see RAC#s problem http://sqlblog.com/blogs/joe_chang/...inking-oracle-rac-think-again-whitepaper.aspx here. I see that peer-to-peer replication provides such an equivalent feature in SQL Server.
    satya, May 9, 2011
    #3

  3. Jahanzaib Member

    Microsoft provide only High Availability and active/passive nodes,there is no active active and no load balancing,if you are trying to find a solution for Load Balancing then check NLB by microsoft and there are such other software base load balancing are available
    Jahanzaib, May 9, 2011
    #4

Share This Page