{"id":9476,"date":"2016-12-05T18:28:44","date_gmt":"2016-12-05T17:28:44","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/"},"modified":"2023-07-18T07:41:59","modified_gmt":"2023-07-18T05:41:59","slug":"sql-server-2016-distributed-availability-groups-and-cascaded-replicas","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/","title":{"rendered":"SQL Server 2016: distributed availability groups and cascaded replicas"},"content":{"rendered":"<p>During the last MVP summit, we had some interesting discussions about availability groups with the SQL Server team and I remember someone asked for managing scenarios like <a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/server.111\/b28294\/cascade_appx.htm#g639625\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle cascaded destinations<\/a> and the good news is that SQL Server 2016 already addresses this kind of scenario with distributed availability groups. For example, let\u2019s say you have to manage heavily reporting activity on your application and a solution would be to offload this activity across several secondary read-only replicas. So, a typical architecture as follows:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13385 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228.jpg\" alt=\"blog 110 - 0 - initial infra AG\" width=\"600\" height=\"307\" \/><\/p>\n<p>We basically want to achieve high availability on the primary datacenter (DATACENTER1) and to use the secondary datacenter as DR and at the same time to offload reporting activity on secondary replicas. But let\u2019s say you get a low network bandwidth \u2013 (WAN classified with ~= 150 \/ 200 mbps) between your two datacenters which are geographically dispersed from each other. Regarding your current workload against the availability group, we may potentially experience high network traffic when the number of secondary replicas increases on the DR site. Indeed, the number of log blocks to replicate is directly proportional to the number of secondary replicas for the same payload.<\/p>\n<p>I decided to simulate this scenario on my lab environment which reflects the above scenario (2 replicas on the first datacenter and four other replicas on the second datacenter). I used two Lenovo T530 laptop with Hyper-V to simulate the whole environment with a cross datacenter network connection handled by two RRAS servers.<\/p>\n<p>In addition, for a sake of precision, let\u2019s describe the test protocol:<\/p>\n<ul>\n<li>I used a script which inserts a bunch of data from the primary replica (~ 900MB of data)<\/li>\n<li>I ran the same workload test after adding one asynchronous read-only replica at time on each test up to 4 replicas.<\/li>\n<li>I collected performance data from various perfmon counters focused on the availability group network stack (both primary site and DR site)<\/li>\n<\/ul>\n<p><span style=\"color: #000000; font-family: Calibri;\">Here the output of the whole test.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13386\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-1-network-usage-trend-AG-e1480961547580.jpg\" alt=\"blog 110 - 1 - network usage trend AG\" width=\"800\" height=\"400\" \/><\/p>\n<p>The picture above is pretty clear here. We notice the network bandwidth grows up when adding secondary replicas. In the last test, the network bandwidth reached 400 Mbps (received traffic) on the remote datacenter while that reached for primary replica 600 Mbps (send traffic). Why have we got a difference between network bandwidth consumption between the primary replica and remote datacenter? Well, the answer is simple: network bandwidth consumption on remote datacenter doesn\u2019t include network traffic from the secondary located on the first datacenter for high-availability.<\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">We may also notice the third iteration of the test (1 primary + 1 secondary sync + 2 secondaries async) is showing up a critical point if we have to face a scenario that includes a WAN connection between the two datacenters with a maximum network bandwidth of 200 Mbps. Indeed in this case, the network bandwidth could be quickly saturated by the replication traffic between all the replicas and here probably the first symptoms you may encountered in this case:<\/span><\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">\u00a0<\/span><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13387\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-3-AG-DMV-monitoring.jpg\" alt=\"blog 110 - 3 - AG DMV monitoring\" width=\"806\" height=\"142\" \/><\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">A continuous high log send queue size for each concerned secondary replica on the remote datacenter (250 MB on average in my case)&#8230;<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13388\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-3-AG-wait-stats.jpg\" alt=\"blog 110 - 3 - AG wait stats\" width=\"768\" height=\"66\" \/><\/p>\n<p>You may minimize the network overhead by isolating the replication traffic to its own network but in some cases if you\u2019re unlucky it will not be enough. This is a situation which may be solved by introducing distributed availability groups and the cascaded destinations principle as shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13389\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-4-distributed-infra-AG-e1480961753861.jpg\" alt=\"blog 110 - 4 - distributed infra AG\" width=\"600\" height=\"338\" \/><\/p>\n<p>Distributed availability group feature will permit to offload the replication traffic from the primary to the read-only secondaries by using a replica on the second datacenter. Thus, we are able to reduce drastically the network bandwidth from 4 replicas to only one. In addition, adding one or several other replicas may be considered because this new architecture is more scalable and we will only impact local network bandwidth on the second datacenter.<\/p>\n<p>Here my new lab configuration after applying distributed availability groups on the previous architecture.<\/p>\n<ul>\n<li>In the first datacenter, one availability group AdvGrp that includes two replicas in synchronous replication and automatic failover for HA purpose<\/li>\n<li>In the second datacenter, one availability AdvGrpDR that includes four replicas enrolled as read-only.<\/li>\n<li>One distributed availability group AdvDistGrp which makes the cascade between the two aforementioned availability groups<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13390\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-5-distributed-cfg-AG-e1480961827775.jpg\" alt=\"blog 110 - 5 - distributed cfg AG\" width=\"800\" height=\"240\" \/><\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">Let\u2019s run the same workload test on the new architecture and let\u2019s have a look at the new output:<\/span><\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">The log send queue size got back to normal at the primary replica level on the first datacenter by cascading all the previous replication traffic from the primary replica located to the second datacenter (AdvGrpDR availability group).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13392\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-6-AG-DMV-monitoring-distrib.jpg\" alt=\"blog 110 - 6 - AG DMV monitoring distrib\" width=\"592\" height=\"166\" \/><\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">From a wait statistics perspective, we got rid of HADR_DATABASE_FLOW_CONTROL meaning we did not saturated the network link between the 2 datacenters<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13393\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-7-AG-wait-stats-distributed.jpg\" alt=\"blog 110 - 7 - AG wait stats distributed\" width=\"679\" height=\"63\" \/><\/p>\n<p><span style=\"color: #000000; font-family: Calibri;\">The picture below confirms the replication traffic dropped drastically with this new configuration (150 Mbps vs 400 Mbps from the first architecture).<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-13394 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-8-perfmon-AG-distributed-e1480962025508.jpg\" alt=\"blog 110 - 8 - perfmon AG distributed\" width=\"600\" height=\"207\" \/><\/p>\n<p><strong><span style=\"text-decoration: underline;\">Bottom line<\/span><\/strong><\/p>\n<p>In this blog\u00a0post I tried to demonstrate\u00a0using distributed availability groups to cascade the replication traffic to another replica may be a good idea in order to address scenarios which include many secondary replicas on a remote location with a Bylow network bandwidth. However introducing distributed availability groups has a cost in terms of management because we have to deal with an additional layer of complexity. But if the rewards make the effort worthwhile we should consider this kind of architecture.<\/p>\n<p>By David Barbarin<\/p>\n","protected":false},"excerpt":{"rendered":"<p>During the last MVP summit, we had some interesting discussions about availability groups with the SQL Server team and I remember someone asked for managing scenarios like Oracle cascaded destinations and the good news is that SQL Server 2016 already addresses this kind of scenario with distributed availability groups. For example, let\u2019s say you have [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":9486,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[297,860,862,84,67],"type_dbi":[],"class_list":["post-9476","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-availability-groups","tag-direct-seeding","tag-distributed-availability-group","tag-high-availability","tag-performance"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server 2016: distributed availability groups and cascaded replicas<\/title>\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.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: distributed availability groups and cascaded replicas\" \/>\n<meta property=\"og:description\" content=\"During the last MVP summit, we had some interesting discussions about availability groups with the SQL Server team and I remember someone asked for managing scenarios like Oracle cascaded destinations and the good news is that SQL Server 2016 already addresses this kind of scenario with distributed availability groups. For example, let\u2019s say you have [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-05T17:28:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-18T05:41:59+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"307\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Microsoft Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Microsoft Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server 2016: distributed availability groups and cascaded replicas\",\"datePublished\":\"2016-12-05T17:28:44+00:00\",\"dateModified\":\"2023-07-18T05:41:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/\"},\"wordCount\":880,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg\",\"keywords\":[\"Availability groups\",\"direct seeding\",\"distributed availability group\",\"High availability\",\"Performance\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/\",\"name\":\"SQL Server 2016: distributed availability groups and cascaded replicas\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg\",\"datePublished\":\"2016-12-05T17:28:44+00:00\",\"dateModified\":\"2023-07-18T05:41:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg\",\"width\":600,\"height\":307},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: distributed availability groups and cascaded replicas\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\",\"name\":\"Microsoft Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g\",\"caption\":\"Microsoft Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server 2016: distributed availability groups and cascaded replicas","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.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: distributed availability groups and cascaded replicas","og_description":"During the last MVP summit, we had some interesting discussions about availability groups with the SQL Server team and I remember someone asked for managing scenarios like Oracle cascaded destinations and the good news is that SQL Server 2016 already addresses this kind of scenario with distributed availability groups. For example, let\u2019s say you have [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/","og_site_name":"dbi Blog","article_published_time":"2016-12-05T17:28:44+00:00","article_modified_time":"2023-07-18T05:41:59+00:00","og_image":[{"width":600,"height":307,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server 2016: distributed availability groups and cascaded replicas","datePublished":"2016-12-05T17:28:44+00:00","dateModified":"2023-07-18T05:41:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/"},"wordCount":880,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg","keywords":["Availability groups","direct seeding","distributed availability group","High availability","Performance"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/","name":"SQL Server 2016: distributed availability groups and cascaded replicas","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg","datePublished":"2016-12-05T17:28:44+00:00","dateModified":"2023-07-18T05:41:59+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-110-0-initial-infra-AG-e1480961452228-1.jpg","width":600,"height":307},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-distributed-availability-groups-and-cascaded-replicas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: distributed availability groups and cascaded replicas"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4","name":"Microsoft Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c44a1a792c059f24055763aa77d80a244467f6eef724a8bd13db8d4a350b7a4c?s=96&d=mm&r=g","caption":"Microsoft Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/microsoft-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9476","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/26"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9476"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9476\/revisions"}],"predecessor-version":[{"id":26805,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9476\/revisions\/26805"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9486"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9476"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}