{"id":477,"date":"2016-02-26T07:50:42","date_gmt":"2016-02-26T07:50:42","guid":{"rendered":"http:\/\/www.faceofit.com\/?p=477"},"modified":"2020-04-13T07:02:35","modified_gmt":"2020-04-13T07:02:35","slug":"sql-server-2016-always-on-enhancements","status":"publish","type":"post","link":"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/","title":{"rendered":"SQL Server 2016 Always On Enhancements"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/#SQL_Server_2016_Always_On_Enhancements\" title=\"SQL Server 2016 Always On Enhancements\">SQL Server 2016 Always On Enhancements<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/#SQL_Server_2016_Always_On_Availability_Groups_Features\" title=\"SQL Server 2016 Always On\u00a0Availability Groups Features\">SQL Server 2016 Always On\u00a0Availability Groups Features<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/#Readable_Secondary_load_balancing\" title=\"Readable Secondary load balancing\">Readable Secondary load balancing<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"SQL_Server_2016_Always_On_Enhancements\"><\/span><strong>SQL Server 2016 Always On Enhancements<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>I have already spoken about <a href=\"http:\/\/www.faceofit.com\/sql-server-2016-new-features\/\" class=\"external external_icon\" rel=\"nofollow\">SQL 2016 Performance features<\/a> and <a href=\"http:\/\/www.faceofit.com\/sql-server-2016-security-features\/\" class=\"external external_icon\" rel=\"nofollow\">Security features<\/a>. SQL Server Always On was first introduced in 2012 Enterprise Edition. From day 1, it looked promising and had great adoption rates all across SQL Server Enterprise Edition deployments worldwide. SQL Server 2014 enhanced it a bit more with the introduction of additional Secondary Replicas, from 4 to 8. It also introduced &#8220;Add Azure Replica Wizard&#8221; to have a Highly Available site hosted in Azure for both DR and HA.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-478 size-full\" src=\"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/sql-always-on-3.png\" alt=\"SQL Server 2016 Always On Enhancements\" width=\"576\" height=\"349\" \/><\/p>\n<p>With SQL Server 2016, Microsoft introduced additional enhancements for the already good Always On Availability groups feature.<\/p>\n<blockquote><p><strong><span style=\"color: #ff0000;\">Microsoft has introduced a basic edition of Always On Availability Groups for SQL Server 2016 Standard Edition. It will\u00a0provide support for One\u00a0primary and One secondary replica, No additional Replicas. This capability replaces Database Mirroring technology for high availability.<\/span><\/strong><\/p><\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"SQL_Server_2016_Always_On_Availability_Groups_Features\"><\/span>SQL Server 2016 Always On\u00a0Availability Groups Features<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4>Greater scalability:<\/h4>\n<ul>\n<li>Load balancing with multiple readable secondaries<\/li>\n<li>Increased number of auto-failover targets<\/li>\n<li>Transaction Log transport performance<\/li>\n<\/ul>\n<h4>Improved manageability:<\/h4>\n<ul>\n<li>Distributed Transaction Controller (DTC) support<\/li>\n<li>Database-level health monitoring<\/li>\n<li>Group managed service account<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-479 size-full\" src=\"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/sql-always-on-1.png\" alt=\"SQL Server 2016 Always On Enhancements\" width=\"544\" height=\"419\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Readable_Secondary_load_balancing\"><\/span>Readable Secondary load balancing<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-480 size-full\" src=\"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/sql-always-on-4.png\" alt=\"SQL Server 2016 Always On Enhancements\" width=\"887\" height=\"405\" \/><\/p>\n<p>You can now Load-balance read-intent connection requests and is now supported across a set of read-only replicas. The previous behavior always directed connections to the first available read-only replica in the routing list.<\/p>\n<p>More from <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bb510411(v=sql.130).aspx#HighAvailability\" class=\"external external_icon\" rel=\"nofollow\">Microsoft Official Documentation here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server 2016 Always On Enhancements I have already spoken about SQL 2016 Performance features and Security features. SQL Server Always On was first introduced in 2012 Enterprise Edition. From day 1, it looked promising and had great adoption rates all across SQL Server Enterprise Edition deployments worldwide. SQL Server 2014 enhanced it a bit more with the introduction of additional Secondary Replicas, from 4 to 8. It also introduced &#8220;Add Azure Replica Wizard&#8221; to have a Highly Available site hosted in Azure for both DR and HA. With SQL Server 2016, Microsoft introduced additional enhancements for the already good [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,41],"tags":[39,51,42,52,55,56,57,58],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server 2016 Always On Enhancements - Gig XP<\/title>\n<meta name=\"description\" content=\"SQL Server 2016, Microsoft introduced additional enhancements for the already good Always On Availability groups feature\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 Always On Enhancements - Gig XP\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2016, Microsoft introduced additional enhancements for the already good Always On Availability groups feature\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/\" \/>\n<meta property=\"og:site_name\" content=\"Gig XP\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/Face-of-it-501680523211743\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-26T07:50:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-04-13T07:02:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/sql-always-on-3.png\" \/>\n<meta name=\"author\" content=\"IG\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@faceofit1\" \/>\n<meta name=\"twitter:site\" content=\"@FaceofIT1\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"IG\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/\",\"url\":\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/\",\"name\":\"SQL Server 2016 Always On Enhancements - Gig XP\",\"isPartOf\":{\"@id\":\"https:\/\/www.gigxp.com\/#website\"},\"datePublished\":\"2016-02-26T07:50:42+00:00\",\"dateModified\":\"2020-04-13T07:02:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d\"},\"description\":\"SQL Server 2016, Microsoft introduced additional enhancements for the already good Always On Availability groups feature\",\"breadcrumb\":{\"@id\":\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gigxp.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 Always On Enhancements\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gigxp.com\/#website\",\"url\":\"https:\/\/www.gigxp.com\/\",\"name\":\"Gig XP\",\"description\":\"The Enterprise Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gigxp.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d\",\"name\":\"IG\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gigxp.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g\",\"caption\":\"IG\"},\"sameAs\":[\"http:\/\/faceofit.com\",\"https:\/\/twitter.com\/faceofit1\"],\"url\":\"https:\/\/www.gigxp.com\/author\/indro13\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2016 Always On Enhancements - Gig XP","description":"SQL Server 2016, Microsoft introduced additional enhancements for the already good Always On Availability groups feature","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 Always On Enhancements - Gig XP","og_description":"SQL Server 2016, Microsoft introduced additional enhancements for the already good Always On Availability groups feature","og_url":"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/","og_site_name":"Gig XP","article_publisher":"http:\/\/www.facebook.com\/Face-of-it-501680523211743","article_published_time":"2016-02-26T07:50:42+00:00","article_modified_time":"2020-04-13T07:02:35+00:00","og_image":[{"url":"http:\/\/www.faceofit.com\/wp-content\/uploads\/2016\/02\/sql-always-on-3.png"}],"author":"IG","twitter_card":"summary_large_image","twitter_creator":"@faceofit1","twitter_site":"@FaceofIT1","twitter_misc":{"Written by":"IG","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/","url":"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/","name":"SQL Server 2016 Always On Enhancements - Gig XP","isPartOf":{"@id":"https:\/\/www.gigxp.com\/#website"},"datePublished":"2016-02-26T07:50:42+00:00","dateModified":"2020-04-13T07:02:35+00:00","author":{"@id":"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d"},"description":"SQL Server 2016, Microsoft introduced additional enhancements for the already good Always On Availability groups feature","breadcrumb":{"@id":"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.gigxp.com\/sql-server-2016-always-on-enhancements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gigxp.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 Always On Enhancements"}]},{"@type":"WebSite","@id":"https:\/\/www.gigxp.com\/#website","url":"https:\/\/www.gigxp.com\/","name":"Gig XP","description":"The Enterprise Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gigxp.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gigxp.com\/#\/schema\/person\/6244c054d0028f41846edce3a1707a2d","name":"IG","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gigxp.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8b03fdc21ab68c3d7d72b6f7462c820b?s=96&d=retro&r=g","caption":"IG"},"sameAs":["http:\/\/faceofit.com","https:\/\/twitter.com\/faceofit1"],"url":"https:\/\/www.gigxp.com\/author\/indro13\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/posts\/477"}],"collection":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/comments?post=477"}],"version-history":[{"count":0,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/posts\/477\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/media?parent=477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/categories?post=477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gigxp.com\/wp-json\/wp\/v2\/tags?post=477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}