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?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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