{"id":11863,"date":"2018-10-23T18:06:25","date_gmt":"2018-10-23T16:06:25","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/"},"modified":"2018-10-23T18:06:25","modified_gmt":"2018-10-23T16:06:25","slug":"sql-server-availability-groups-sql-browser-and-shared-memory-considerations","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/","title":{"rendered":"SQL Server availability groups, SQL Browser and Shared Memory considerations"},"content":{"rendered":"<p>Few weeks ago, my colleagues and me discussed availability groups and network considerations for one of our customers including disabling SQL Browser service and shared memory protocol. The point was disabling both features may lead to unexpected behaviors when creating availability groups.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-0-AG-network-banner.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28715\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-0-AG-network-banner.jpg\" alt=\"blog 145 - 0 - AG network banner\" width=\"406\" height=\"126\" \/><\/a><\/p>\n<p>Let\u2019s start with the SQL Browser service. It is not uncommon to disable this service at customer shops and to use directly SQL Server listen ports instead. But if you go trough the availability group wizard you will find there a plenty of blockers when actions than require connecting to the secondary replica as adding a database, performing a failover and so on.<\/p>\n<p>Disabling the SQL Browser service doesn\u2019t mean you can not reach out your SQL Server instance by using the named instance format SERVER\\INSTANCE. There are some scenarios that\u2019s work perfectly including either connecting from the local server through the shared memory or by using SQL Server aliases. Let\u2019s say my infrastructure includes 2 AG replicas vmtest2012r04\\SQL2014 and vmtest2012r05\\SQL2014. SQL browser is disabled and shared memory is enabled on each. There are no aliases as well. If you try to connect from the vmtest2012r04\\SQL2014 by using named instance format it will work on the local replica (through shared memory) but it won\u2019t work if you try to connect to the remote replica vmtest2012r05\\SQL2014. In the latest case, you have will to use SERVER,PORT format as shown below:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">C:\\Users\\dab&gt;sqlcmd -S vmtest2012r204\\SQL2014 -Q\"SELECT 'OK' AS connection\"\nconnection\n---------\nOK\n\n(1 rows affected)\n\nC:\\Users\\dab&gt;sqlcmd -S vmtest2012r205\\SQL2014 -Q\"SELECT 'OK' AS connection\"\nSqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : SQL Server Network Inte\nrfaces: Error Locating Server\/Instance Specified [xFFFFFFFF]. .\nSqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login timeout expired.\nSqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : A network-related or in\nstance-specific error has occurred while establishing a connection to SQL Server\n. Server is not found or not accessible. Check if instance name is correct and i\nf SQL Server is configured to allow remote connections. For more information see\n SQL Server Books Online..\n\nC:\\Users\\dab&gt;sqlcmd -S vmtest2012r205,1453 -Q\"SELECT 'OK' AS connection\"\nconnection\n---------\nOK<\/pre>\n<p>&nbsp;<\/p>\n<p>But I guess this is not a big surprise for you. This kind of configuration works well with availability group but at the cost of some compromises. Indeed, creating an availability group remains pretty easy and you just have to keep using SERVER,PORT format when the wizard asks for connection information.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28705\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg\" alt=\"blog 145 - 1 - AG wizard - replica\" width=\"800\" height=\"493\" \/><\/a><\/p>\n<p>But the game is different for adding a database to the AG or at least any operation that requires to connect to the replicas. In this case the Wizard forces to connect to the second replica by using SERVER\\INSTANCE format leading to get stuck at this step.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-2-AG-wizard-add-DB.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28706\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-2-AG-wizard-add-DB.jpg\" alt=\"blog 145 - 2 - AG wizard - add DB\" width=\"607\" height=\"391\" \/><\/a><\/p>\n<p><span style=\"text-decoration: line-through\"><strong>The only way is to go through T-SQL script (or PowerShell command) to change the format to SERVER,PORT. Probably something that may be fixed by Microsoft in the future.<\/strong><\/span><\/p>\n<p><strong>Update 24.10.2018: A correction from Damien Berchotteau: You can override the connection string by using <em>server=server_name,port<\/em> and continue to go through SSMS.<\/strong><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-3-AG-wizard-connection-string.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28790\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-3-AG-wizard-connection-string.jpg\" alt=\"blog 145 - 3 - AG wizard - connection string\" width=\"452\" height=\"210\" \/><\/a><\/p>\n<p>Let\u2019s add now to the equation disabling the shared memory protocol on each replica. I met some customers who disable it to meet their internal best practices because their applications are not intended to connect locally on the same server than their database engine. At the first glance, this is not a bad idea but we may get in trouble with operations performed on availability group architectures. This is a least what we experienced every time we were in this specific context. For instance, if I try to create an availability group, I will face the following timeout error message:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-3-AG-wizard-shared-memory-disabled.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28707\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-3-AG-wizard-shared-memory-disabled.jpg\" alt=\"blog 145 - 3 - AG wizard - shared memory disabled\" width=\"778\" height=\"522\" \/><\/a><\/p>\n<p>This is a pretty weird issue and to get more details, we have to take a look at the cluster log. Here the interesting sample of messages we may find out:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">...2018\/10\/22-20:42:51.436 ERR   [RES] SQL Server Availability Group &lt;AG2014&gt;: [hadrag] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Error Locating Server\/Instance Specified [xFFFFFFFF].  (268435455)\n...2018\/10\/22-20:42:51.436 ERR   [RES] SQL Server Availability Group &lt;AG2014&gt;: [hadrag] ODBC Error: [HYT00] [Microsoft][SQL Server Native Client 11.0]Login timeout expired (0)\n...2018\/10\/22-20:42:51.436 ERR   [RES] SQL Server Availability Group &lt;AG2014&gt;: [hadrag] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. (268435455)\n...2018\/10\/22-20:42:51.436 INFO  [RES] SQL Server Availability Group &lt;AG2014&gt;: [hadrag] Could not connect to SQL Server (rc -1)\n...2018\/10\/22-20:42:51.436 INFO  [RES] SQL Server Availability Group &lt;AG2014&gt;: [hadrag] SQLDisconnect returns following information\n...2018\/10\/22-20:42:51.451 ERR   [RES] SQL Server Availability Group &lt;AG2014&gt;: [hadrag] ODBC Error: [08003] [Microsoft][ODBC Driver Manager] Connection not open (0)\n...2018\/10\/22-20:42:51.451 ERR   [RES] SQL Server Availability Group &lt;AG2014&gt;: [hadrag] Failed to connect to SQL Server\n...2018\/10\/22-20:42:51.451 ERR   [RHS] Online for resource AG2014 failed.<\/pre>\n<p>&nbsp;<\/p>\n<p>It seems that the RHS.exe, through the resource associated to my AG, is not able to connect to the SQL Server replica during the initialization phase. According to the above cluster log, the ODBC connection seems to be limited to connect by using INSTANCE\\NAME format and as I far as I know there is no interface to change it with the AG cluster resource DLL (thanks Microsoft guys\u00a0for confirming this point). Therefore, disabling both SQL Browser and shared memory leads to the AG cannot be brought online because a communication channel cannot be established between the primary and the cluster service. My friend MVP <a href=\"https:\/\/twitter.com\/Conseilit\" target=\"_blank\" rel=\"noopener noreferrer\">Christophe Laporte <\/a>tried also some funny tests by\u00a0trying to create custom\u00a0DSN connections without luck.\u00a0\u00a0\u00a0So, the simplest way to fix it if you want to keep disable the SQL Browser service is to enable the shared memory on each replica. Another workaround may consist in using SQL aliases but it leads to a static configuration that requires to document well your architecture.<\/p>\n<p>In a nutshell, disabling SQL Browser limits the AG operations that can be done through the GUI. Adding the shared memory to the equation may have a bigger impact to the underlying WSFC infrastructure that you have to be aware of. According to my tests, this behavior seems to be\u00a0same with versions from SQL2012 to SQL2017 (on Windows) regardless the WSFC version.<\/p>\n<p>Hope this helps!<\/p>\n<p><span style=\"float: none;background-color: #ffffff;color: #333333;cursor: text;font-family: Georgia,'Times New Roman','Bitstream Charter',Times,serif;font-size: 16px;font-style: normal;font-variant: normal;font-weight: 400;letter-spacing: normal;text-align: left;text-decoration: none;text-indent: 0px;text-transform: none\">By David Barbarin<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Few weeks ago, my colleagues and me discussed availability groups and network considerations for one of our customers including disabling SQL Browser service and shared memory protocol. The point was disabling both features may lead to unexpected behaviors when creating availability groups. Let\u2019s start with the SQL Browser service. It is not uncommon to disable [&hellip;]<\/p>\n","protected":false},"author":26,"featured_media":11865,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,99],"tags":[297,38,84,1469,1470,750],"type_dbi":[],"class_list":["post-11863","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-sql-server","tag-availability-groups","tag-cluster","tag-high-availability","tag-sql-browser","tag-sql-network","tag-wsfc"],"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 availability groups, SQL Browser and Shared Memory considerations<\/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-availability-groups-sql-browser-and-shared-memory-considerations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server availability groups, SQL Browser and Shared Memory considerations\" \/>\n<meta property=\"og:description\" content=\"Few weeks ago, my colleagues and me discussed availability groups and network considerations for one of our customers including disabling SQL Browser service and shared memory protocol. The point was disabling both features may lead to unexpected behaviors when creating availability groups. Let\u2019s start with the SQL Browser service. It is not uncommon to disable [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-23T16:06:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"493\" \/>\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=\"5 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-availability-groups-sql-browser-and-shared-memory-considerations\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server availability groups, SQL Browser and Shared Memory considerations\",\"datePublished\":\"2018-10-23T16:06:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/\"},\"wordCount\":783,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg\",\"keywords\":[\"Availability groups\",\"Cluster\",\"High availability\",\"SQL Browser\",\"SQL Network\",\"WSFC\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/\",\"name\":\"SQL Server availability groups, SQL Browser and Shared Memory considerations\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg\",\"datePublished\":\"2018-10-23T16:06:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg\",\"width\":800,\"height\":493},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server availability groups, SQL Browser and Shared Memory considerations\"}]},{\"@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 availability groups, SQL Browser and Shared Memory considerations","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-availability-groups-sql-browser-and-shared-memory-considerations\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server availability groups, SQL Browser and Shared Memory considerations","og_description":"Few weeks ago, my colleagues and me discussed availability groups and network considerations for one of our customers including disabling SQL Browser service and shared memory protocol. The point was disabling both features may lead to unexpected behaviors when creating availability groups. Let\u2019s start with the SQL Browser service. It is not uncommon to disable [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/","og_site_name":"dbi Blog","article_published_time":"2018-10-23T16:06:25+00:00","og_image":[{"width":800,"height":493,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg","type":"image\/jpeg"}],"author":"Microsoft Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Microsoft Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server availability groups, SQL Browser and Shared Memory considerations","datePublished":"2018-10-23T16:06:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/"},"wordCount":783,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg","keywords":["Availability groups","Cluster","High availability","SQL Browser","SQL Network","WSFC"],"articleSection":["Database Administration &amp; Monitoring","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/","name":"SQL Server availability groups, SQL Browser and Shared Memory considerations","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg","datePublished":"2018-10-23T16:06:25+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-145-1-AG-wizard-replica-e1540314563608.jpg","width":800,"height":493},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-availability-groups-sql-browser-and-shared-memory-considerations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server availability groups, SQL Browser and Shared Memory considerations"}]},{"@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\/11863","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=11863"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11863\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11865"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11863"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}