Always on with sql server 2014 or 2012

  • Hi

    We need to run Always on , on our sql servers.

    Is there any upgrade or benefits on sql server 2014 about Always on ?

    Or

    Should I Upgrade to 2014 to use stable Always on ?

    Thankyou

  • sm_iransoftware (1/14/2015)


    Hi

    We need to run Always on , on our sql servers.

    Is there any upgrade or benefits on sql server 2014 about Always on ?

    Or

    Should I Upgrade to 2014 to use stable Always on ?

    Thankyou

    Upgrade from what?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • sm_iransoftware (1/14/2015)


    Hi

    We need to run Always on , on our sql servers.

    Is there any upgrade or benefits on sql server 2014 about Always on ?

    Or

    Should I Upgrade to 2014 to use stable Always on ?

    Thankyou

    There were some improvements to AO in 2014, the number of secondarys increased to 8 from 4 and a fix to the state of the secondarys when the primary goes offline.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • In addition to what Perry says, I also understand that there are a number of internals improvements leading to a higher degree of stability and better performance overall.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply