Post reply

Always On in Std Edition. whats actually available?

  • July 15, 2013 at 7:56 am

    #296391

    In the "Features Support" documentation on technet it says that Always On Failover Clustering is available on SQL server Standard Edition for up to 2 nodes.

    Im not sure what this means though. does this mean i can have secondaries for offloading reporting etc if i use standard edition?

  • July 15, 2013 at 8:33 am

    #1632497

    Hi,

    Always On Failover Clustering in standard edition is simply failover clustering. It does not offer you read only replicas that is an enterprise only feature so offloading reporting would have to be done by other means.

    In standard edition you can have a 2 node cluster, the nodes can be co-located or geographically separate.

    Hope that helps a little.

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • July 15, 2013 at 8:51 am

    #1632504

    that helps a lot. By tacking "always on" to "failover Clustering" in the documentation microsoft confused the issue.

    when you say a failover cluster can be geographically disparate, you mean by using some storage replication technology, as per a stretch cluster in any version of sql server, is that correct?

  • July 15, 2013 at 8:53 am

    #1632509

    I believe since 2008R2 you can have the nodes in separate subnets alleviating the need for a stretch VLAN. But yes you'd need some sort of storage replication going on.

    Glad it helped.

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • July 15, 2013 at 9:52 am

    #1632542

    perfect, great help, thank you!

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

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