{"id":12827,"date":"2019-09-20T05:11:16","date_gmt":"2019-09-20T03:11:16","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/"},"modified":"2023-07-17T15:11:05","modified_gmt":"2023-07-17T13:11:05","slug":"when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/","title":{"rendered":"When Read-Scale availability groups and Windows Failover Cluster are not good friends"},"content":{"rendered":"

A couple of days ago, with some fellow French data platform MVPS (<\/span>@thesqlgrrrl<\/a> and <\/span>@Conseilit<\/a>) we discussed an issue around Read-Scale availability groups and it made me think I had forgotten to share about <\/span>a weird behavior I experienced with them. \u00a0<\/span><\/span><\/span><\/p>\n

Basically, <\/span><\/span>Read-Scale availability groups<\/span><\/a> <\/u><\/span><\/span>are clusterless infrastructures meaning there is no need to install an underlying cluster. Obviously, you will not benefit from resource orchestration and automatic failover, but this is obviously the intended behavior and their sole purpose and design is to <\/span>scale<\/span><\/em> out a <\/span>read<\/span><\/em> workload<\/span><\/span><\/span><\/p>\n

Let\u2019s say you have installed a Read-Scale availability group that includes 2 replicas with one primary and one secondary. <\/span><\/span><\/p>\n

\"\"<\/p>\n

If there is a network failure between replicas the normal behavior should be:<\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>The primary replica continues to handle the R\/W workload. Regarding the replication type (sync\/async) the current queries may be blocked until reaching the session timeout and then everything should back to normal. Obviously, transactions will fill up the transaction log until the network outage is fixed.<\/span><\/span><\/span><\/p>\n

–<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span>The secondary replica continues to handle the RO traffic assuming you use a direct connection to it and you don\u2019t use the transparent redirection capability of the AG listener which may lead you to face the following error message:<\/span><\/span><\/span><\/p>\n

Error: Microsoft ODBC Driver 17 for SQL Server : Unable to access the ‘<database>’ database because no online secondary replicas are enabled for read-only access. Check the availability group configuration to verify that at least one secondary replica is configured for read-only access. Wait for an enabled replica to come online, and retry your read-only operation..<\/span><\/span><\/i><\/b><\/p>\n

But here comes the interesting part of the story. \u00a0Let\u2019s introduce in the game the Windows Failover Cluster. As said previously there is no need to install such HA feature on Windows to make the Read-Scale AG working correctly. But suppose now you want to test read scale capabilities on an existing AG infrastructure that relies on the underlying cluster for HA. Why to do this? Well, because in my case with my customer we didn\u2019t want to provision a dedicated infrastructure to only test Read-Scale AGs and we wanted to take advantage of the existing one for that. Anyway, referring to the <\/span><\/span>Microsoft documentation<\/span><\/a> and my google Fu as well, we didn\u2019t find out any know evidence of \u201cincompatibility\u201d of using Read-Scale AG in conjunction of the Windows Failover Cluster. So, we just went ahead, and we added a new SQL Server 2017 Read-Scale AG to an existing infrastructure that already included other AGs for HA (and therefore implicitly an underlying WSFC installed).<\/span><\/span><\/span><\/p>\n

\"\"<\/p>\n

The new installed Read-Scale AG was configured correctly as show below:<\/span><\/span><\/p>\n

\"\"<\/p>\n

Simulating a failure scenario to voluntary shutdown the WSFC gave surprising results because we didn\u2019t expect to see connections issues with the new Read-Scale AG both on the primary and the secondary. Let\u2019s clarify this point: As mentioned above, for AG with HA capabilities, this result is consistent with a failed Windows Failover Cluster that has compromised the AG infrastructure. But with Read-Scale AGs because they are not tied to any HA mechanism, we didn\u2019t expect to see the AG to get a \u201cResolving\u201d state with no access to the primary database as confirmed with the following error message:<\/span><\/span><\/p>\n

Msg 983, Level 14, State 1, Line 3<\/em><\/strong>
\nUnable to access availability database ‘<database>’ because the database replica is not in the PRIMARY or SECONDARY role. <\/em><\/strong>
\nConnections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. <\/em><\/strong>
\nTry the operation again later.<\/em><\/strong><\/p>\n

Looking at the SQL Server error log gave us back some clues:<\/span><\/span><\/p>\n

…<\/em><\/strong>
\nAlways On Availability Groups: Local Windows Server Failover Clustering node is no longer online. This is an informational message only. No user action is required.<\/em><\/strong>
\nAlways On: The availability replica manager is going offline because the local Windows Server Failover Clustering (WSFC) node has lost quorum. This is an informational message only. No user action is required.<\/em><\/strong>
\nAlways On: The local replica of availability group ‘AGSCALE’ is stopping. This is an informational message only. No user action is required.<\/em><\/strong>
\nThe state of the local availability replica in availability group ‘AGSCALE’ has changed from ‘PRIMARY_NORMAL’ to ‘RESOLVING_NORMAL’. The state changed because the local instance of SQL Server is shutting down. For more information, see the SQL Server error log or cluster log. If this is a Windows Server Failover Clustering (WSFC) availability group, you can also see the WSFC management console.<\/em><\/strong>
\nAlways On Availability Groups connection with secondary database terminated for primary database ‘<database>’ on the availability replica ‘WIN20192\\SQL17’ with Replica ID: {5e3d8c42-9c52-449a-aa90-a16665aca055}. This is an informational message only. No user action is required.<\/em><\/strong>
\nThe availability group database “<database>” is changing roles from “PRIMARY” to “RESOLVING” because the mirroring session or availability group failed over due to role synchronization. This is an informational message only. No user action is required.<\/em><\/strong>
\nState information for database ‘<database>’ – Hardened Lsn: ‘(42:10776:1)’ Commit LSN: ‘(42:10768:3)’ Commit Time: ‘Sep 19 2019 1:45PM’<\/em><\/strong>
\nAlways On: The availability replica manager is starting. This is an informational message only. No user action is required.<\/em><\/strong>
\nAlways On Availability Groups: Waiting for local Windows Server Failover Clustering service to start. This is an informational message only. No user action is required.<\/em><\/strong>
\nError: 983, Severity: 14, State: 73.<\/em><\/strong>
\nUnable to access availability database ‘<database>’ because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later.<\/em><\/strong>
\nAlways On Availability Groups: Local Windows Server Failover Clustering service started. This is an informational message only. No user action is required.<\/em><\/strong>
\n\u2026<\/em><\/strong>
\nAttempt to access non-existent or uninitialized availability group with ID ‘{890B3B2C-3BD5-EE9D-1594-899F989700CF}.’. This is usually an internal condition, such as the availability group is being dropped or the local WSFC node has lost quorum. In such cases, and no user action is required.<\/em><\/strong>
\nError: 983, Severity: 14, State: 1.<\/em><\/strong>
\nUnable to access availability database ‘<database>’ because the database replica is not in the PRIMARY or SECONDARY role. Connections to an availability database is permitted only when the database replica is in the PRIMARY or SECONDARY role. Try the operation again later. <\/em><\/strong>
\n…<\/em><\/strong><\/p>\n

The Windows Failover Cluster has shutdown due to a quorum lost (expected result) but also bring the Read-Scale down \u2026 The above output tends to think that even with CLUSTER_TYPE=NONE there still exists a strong relationship between the AG and the underlying cluster. By the way, if you look at the sys.dm_hadr_cluster_members you get info of existing cluster.\u00a0 <\/span><\/span><\/span><\/p>\n

SELECT \n\tmember_name,\n\tmember_type_desc AS member_type,\n\tmember_state_desc AS member_state,\n\tnumber_of_quorum_votes\nFROM sys.dm_hadr_cluster_members<\/pre>\n
\"\"<\/p>\n
From an architecture standpoint, I would say mixing both AGs with HA capabilities and Read-Scale AGs may be not a good practice at all and make no sense, and we probably came across a borderline scenario. However, <\/span><\/span>my feeling is that technically speaking it should work as described in the Microsoft documentation \ud83d\ude42 I noticed this behavior with SQL Server 2017 and different CUs and Windows Server 2016. I got the same behavior with Windows Server 2019 as well.<\/span><\/span><\/p>\n
Please feel free to comment if there is something I omitted !\u00a0<\/span><\/span><\/p>\n
Anyway, we finally dedicated an environment for Read-Scale AGs and we got consist results this time \ud83d\ude42<\/span><\/span><\/p>\n
See you! <\/span><\/span><\/p>\n
By David Barbarin<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
A couple of days ago, with some fellow French data platform MVPS (@thesqlgrrrl and @Conseilit) we discussed an issue around Read-Scale availability groups and it made me think I had forgotten to share about a weird behavior I experienced with them. \u00a0 Basically, Read-Scale availability groups are clusterless infrastructures meaning there is no need to […]<\/p>\n","protected":false},"author":26,"featured_media":12828,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,99],"tags":[297,1076,51,749],"type_dbi":[],"class_list":["post-12827","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-sql-server","tag-availability-groups","tag-read-scale","tag-sql-server","tag-windows-failover-cluster"],"acf":[],"yoast_head":"\nWhen Read-Scale availability groups and Windows Failover Cluster are not good friends - dbi Blog<\/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\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"When Read-Scale availability groups and Windows Failover Cluster are not good friends\" \/>\n<meta property=\"og:description\" content=\"A couple of days ago, with some fellow French data platform MVPS (@thesqlgrrrl and @Conseilit) we discussed an issue around Read-Scale availability groups and it made me think I had forgotten to share about a weird behavior I experienced with them. \u00a0 Basically, Read-Scale availability groups are clusterless infrastructures meaning there is no need to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-20T03:11:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-17T13:11:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"206\" \/>\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=\"7 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\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"When Read-Scale availability groups and Windows Failover Cluster are not good friends\",\"datePublished\":\"2019-09-20T03:11:16+00:00\",\"dateModified\":\"2023-07-17T13:11:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/\"},\"wordCount\":1238,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg\",\"keywords\":[\"Availability groups\",\"read-scale\",\"SQL Server\",\"windows failover cluster\"],\"articleSection\":[\"Database Administration & Monitoring\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/\",\"name\":\"When Read-Scale availability groups and Windows Failover Cluster are not good friends - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg\",\"datePublished\":\"2019-09-20T03:11:16+00:00\",\"dateModified\":\"2023-07-17T13:11:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg\",\"width\":300,\"height\":206},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"When Read-Scale availability groups and Windows Failover Cluster are not good friends\"}]},{\"@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":"When Read-Scale availability groups and Windows Failover Cluster are not good friends - dbi Blog","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\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/","og_locale":"en_US","og_type":"article","og_title":"When Read-Scale availability groups and Windows Failover Cluster are not good friends","og_description":"A couple of days ago, with some fellow French data platform MVPS (@thesqlgrrrl and @Conseilit) we discussed an issue around Read-Scale availability groups and it made me think I had forgotten to share about a weird behavior I experienced with them. \u00a0 Basically, Read-Scale availability groups are clusterless infrastructures meaning there is no need to […]","og_url":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/","og_site_name":"dbi Blog","article_published_time":"2019-09-20T03:11:16+00:00","article_modified_time":"2023-07-17T13:11:05+00:00","og_image":[{"width":300,"height":206,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"When Read-Scale availability groups and Windows Failover Cluster are not good friends","datePublished":"2019-09-20T03:11:16+00:00","dateModified":"2023-07-17T13:11:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/"},"wordCount":1238,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg","keywords":["Availability groups","read-scale","SQL Server","windows failover cluster"],"articleSection":["Database Administration & Monitoring","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/","url":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/","name":"When Read-Scale availability groups and Windows Failover Cluster are not good friends - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg","datePublished":"2019-09-20T03:11:16+00:00","dateModified":"2023-07-17T13:11:05+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/161-0-banner-e1568955631322.jpg","width":300,"height":206},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/when-read-scale-availability-groups-and-windows-failover-cluster-are-not-good-friends\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"When Read-Scale availability groups and Windows Failover Cluster are not good friends"}]},{"@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\/12827","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=12827"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12827\/revisions"}],"predecessor-version":[{"id":26748,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12827\/revisions\/26748"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/12828"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=12827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=12827"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=12827"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=12827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}