{"id":8580,"date":"2016-07-18T18:24:13","date_gmt":"2016-07-18T16:24:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/"},"modified":"2016-07-18T18:24:13","modified_gmt":"2016-07-18T16:24:13","slug":"sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/","title":{"rendered":"SQL Server AlwaysOn: new services packs and new diagnostic capabilities"},"content":{"rendered":"

As you certainly know, the <\/span>SQL Server 2014 SP2<\/span><\/a> has been released by Microsoft with some interesting improvements that concern SQL Server AlwaysOn and availability groups feature. In fact, all of\u00a0them are also\u00a0included into\u00a0SQL Server 2012 SP3<\/a> and SQL Server 2016<\/span> (update 24.09.2016: not yet released with SQL Server 2016<\/strong>). <\/span>Among all fixes and improvements that concern AlwaysOn, I would like to focus on those described in the Microsoft <\/span>KB3173156<\/span><\/a> and <\/span>KB3112363<\/span><\/a>. But in this first blog post, I will just cover\u00a0those who concern the lease timeout which is part of the AlwaysOn health model.<\/p>\n

Did you already\u00a0face lease timeout issue ?\u00a0If yes, you have certainly noticed it is\u00a0an good\u00a0indicator of system wide problem and\u00a0figure out what is the root cause could be a burden task because we missed diagnostic information and we had to correlate different performance metrics\u00a0as well. Fortunately, the release of new service packs provide enhancements in this area.<\/p>\n

Let\u2019s take an example with a 100% CPU utilization\u00a0scenario that leads to make the primary replica unresponsive and unable\u00a0to respond to cluster isAlive() routine. This is typically a situation where we may face a lease timeout issue. After simulating this scenario on my lab environment,h<\/span>ere what I found in the SQL Server error log from my primary replica. (I have voluntary filtered to include only the sample we want to focus on).<\/span><\/p>\n

\"blog<\/a><\/span><\/p>\n

Firstly, we may see different new messages related to lease timeout issues between the range interval 12:39:54 – 12:43:22. For example, the WSFC did not receive a process event signal from SQL Server within the lease timeout period or the lease between AG and the WSFC has expired. Diagnostic messages have been\u00a0enhanced to give us a better\u00a0understanding of the lease issue.\u00a0But at this point we know\u00a0we are facing\u00a0lease timeout but we don\u2019t know the root cause yet. Improvements have also been extented to the cluster log in order\u00a0to provide more insights to the system behavior at the moment of the lease timeout issue as we may see below:<\/p>\n

00000644.00000768::2016\/07\/15-12:40:06.575 ERR\u00a0\u00a0 [RCM] rcm::RcmResource::HandleFailure: (TestGrp)<\/em><\/p>\n

00000644.00000c84::2016\/07\/15-12:40:06.768 INFO [GEM] Node 2: Sending 1 messages as a batched GEM message<\/em><\/p>\n

00000644.00000768::2016\/07\/15-12:40:06.768 INFO [RCM] resource TestGrp: failure count: 0, restartAction: 0 persistentState: 1.<\/em><\/p>\n

00000644.00000768::2016\/07\/15-12:40:06.768 INFO [RCM] numDependents is zero, auto-returning true<\/em><\/p>\n

00000644.00000768::2016\/07\/15-12:40:06.768 INFO [RCM] Will queue immediate restart (500 milliseconds) of TestGrp after terminate is complete.<\/em><\/p>\n

00000644.00000768::2016\/07\/15-12:40:06.768 INFO [RCM] Res TestGrp: ProcessingFailure -> WaitingToTerminate( DelayRestartingResource )<\/em><\/p>\n

00000644.00000768::2016\/07\/15-12:40:06.768 INFO [RCM] TransitionToState(TestGrp) ProcessingFailure–>[WaitingToTerminate to DelayRestartingResource].<\/em><\/p>\n

00000644.00000768::2016\/07\/15-12:40:06.768 INFO [RCM] Res TestGrp: [WaitingToTerminate to DelayRestartingResource] -> Terminating( DelayRestartingResource )<\/em><\/p>\n

00000644.00000768::2016\/07\/15-12:40:06.768 INFO [RCM] TransitionToState(TestGrp) [WaitingToTerminate to DelayRestartingResource]–>[Terminating to DelayRestartingResource].<\/em><\/p>\n

00000cc0.00001350::2016\/07\/15-12:40:12.452 WARN [RES] SQL Server Availability Group: [hadrag] Lease timeout detected<\/span><\/strong>, logging perf counter data collected so far<\/em><\/p>\n

00000cc0.00001350::2016\/07\/15-12:40:12.452 WARN [RES] SQL Server Availability Group: [hadrag] Date\/Time, Processor time(%), Available memory(bytes), Avg disk read(secs), Avg disk write(secs)<\/span><\/em><\/strong><\/p>\n

00000cc0.00001350::2016\/07\/15-12:40:12.452 WARN [RES] SQL Server Availability Group: [hadrag] 7\/15\/2016 10:39:24.0, 8.866394, 912523264.000000, 0.000450, 0.000904<\/span><\/em><\/strong><\/p>\n

00000cc0.00001350::2016\/07\/15-12:40:12.452 WARN [RES] SQL Server Availability Group: [hadrag] 7\/15\/2016 10:39:34.0, 25.287347, 919531520.000000, 0.001000, 0.000594<\/span><\/em><\/strong><\/p>\n

00000cc0.00001350::2016\/07\/15-12:40:12.452 WARN [RES] SQL Server Availability Group: [hadrag] 7\/15\/2016 10:39:44.0, 25.360508, 921534464.000000, 0.000000, 0.001408<\/span><\/em><\/strong><\/p>\n

00000cc0.00001350::2016\/07\/15-12:40:12.452 WARN [RES] SQL Server Availability Group: [hadrag] 7\/15\/2016 10:39:55.0, 81.225454, 921903104.000000, 0.000513, 0.000640<\/span><\/em><\/strong><\/p>\n

00000cc0.00001350::2016\/07\/15-12:40:12.452 WARN [RES] SQL Server Availability Group: [hadrag] 7\/15\/2016 10:40:5.0, 100.000000, 922415104.000000, 0.002800, 0.002619<\/span><\/em><\/strong><\/p>\n

00000cc0.00001350::2016\/07\/15-12:40:12.452 INFO [RES] SQL Server Availability Group: [hadrag] Stopping Health Worker Thread<\/em><\/p>\n

 <\/p>\n

According to the SQL Server error log time range we may notice similar messages that concern the detection of lease timeout with some additional information that came from the perfmon counters (Concerned lines are underlined\u00a0in the sample above). If we reformat the concerned portion into the table below we may get a better identification of our issue<\/p>\n\n\n\n\n\n\n\n\n
Date\/Time<\/strong><\/td>\nProcessor time (%)<\/strong><\/td>\nAvailability memory(bytes)<\/strong><\/td>\nAvg disk read(secs)<\/strong><\/td>\nAvg disk write(secs)<\/strong><\/td>\n<\/tr>\n
10:39:24.0<\/td>\n8.866394<\/td>\n912523264<\/td>\n912523264<\/td>\n0.000904<\/td>\n<\/tr>\n
10:39:34.0<\/td>\n25.287347<\/td>\n919531520<\/td>\n0.001000<\/td>\n0.000594<\/td>\n<\/tr>\n
10:39:44.0<\/td>\n25.360508<\/td>\n921534464<\/td>\n0.000000<\/td>\n0.001408<\/td>\n<\/tr>\n
10:39:55.0<\/td>\n81.225454<\/strong><\/td>\n921903104<\/td>\n0.000513<\/td>\n0.000640<\/td>\n<\/tr>\n
10:40:5.0<\/td>\n100.000000<\/strong><\/td>\n922415104<\/td>\n0.002800<\/td>\n0.002619<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

CPU utilization is what we must focus on here. So getting this valuable information directly to the cluster.log when we troubleshoot lease timeout issue will help us a lot. But just to clarify, this doesn\u2019t mean that it was not possible with older versions but we have to retrieve them in a more complicated way (by using the AlwaysOn_health<\/em> extended event for example).<\/p>\n

Next, other improvements concern existing extended events like availability_group_lease_expired<\/em> and hadr_ag_lease_renewal<\/em>. The next picture points out new available fields like current_time<\/em>, new_timeout<\/em> and state<\/em> as well.<\/p>\n

\"blog<\/a><\/p>\n

Let me show you their interest with another example. This time, I voluntary hang my sqlserver.exe process related to the primary replica in order to trigger an unresponsive lease scenario. I got interesting outputs from the extended event trace on both sides.<\/span><\/p>\n

\"blog<\/a><\/p>\n

From the former primary, there are no related records during the period of the SQL Server process responsiveness but we may see a record at 17:19:11. The lease renewal process fails and\u00a0\u00a0we get a better picture of the problem by looking at the corresponding state (LeaseNotValid<\/em>) followed by the availability_group_lease_expired<\/em> event. Note that the current_time<\/em> (time at which the lease expired) value is greater than the new_timeout<\/em> (time out time, when availability_group_lease_expired is raised) value here – 3215765 > 3064484 – which confirms that we experienced a timeout issue in this case.<\/p>\n

On the new primary, we may notice the start of the lease worker thread but until the concerned replica stabilizes the PRIMARY ONLINE state, it voluntary postpones the lease check process\u00a0(materialized by StartedExcessLeaseSleep \/ ExcessSleepSucceeded state values).<\/p>\n

In the next blog I will talk about improvements in the detection of the availability group replication latency.<\/p>\n

Stay tuned!<\/p>\n

By David Barbarin<\/p>\n","protected":false},"excerpt":{"rendered":"

As you certainly know, the SQL Server 2014 SP2 has been released by Microsoft with some interesting improvements that concern SQL Server AlwaysOn and availability groups feature. In fact, all of\u00a0them are also\u00a0included into\u00a0SQL Server 2012 SP3 and SQL Server 2016 (update 24.09.2016: not yet released with SQL Server 2016). Among all fixes and improvements […]<\/p>\n","protected":false},"author":26,"featured_media":8584,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[466,297,882,883,51,884,885,566],"type_dbi":[],"class_list":["post-8580","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-alwayson","tag-availability-groups","tag-health-monitoring","tag-lease-timeout","tag-sql-server","tag-sql-server-2012-sp3","tag-sql-server-2014-sp2","tag-sql-server-2016"],"acf":[],"yoast_head":"\nSQL Server AlwaysOn: new services packs and new diagnostic capabilities<\/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-alwayson-new-services-packs-and-new-diagnostic-capabilities\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server AlwaysOn: new services packs and new diagnostic capabilities\" \/>\n<meta property=\"og:description\" content=\"As you certainly know, the SQL Server 2014 SP2 has been released by Microsoft with some interesting improvements that concern SQL Server AlwaysOn and availability groups feature. In fact, all of\u00a0them are also\u00a0included into\u00a0SQL Server 2012 SP3 and SQL Server 2016 (update 24.09.2016: not yet released with SQL Server 2016). Among all fixes and improvements […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-18T16:24:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"94\" \/>\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-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/\"},\"author\":{\"name\":\"Microsoft Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"headline\":\"SQL Server AlwaysOn: new services packs and new diagnostic capabilities\",\"datePublished\":\"2016-07-18T16:24:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/\"},\"wordCount\":927,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.jpg\",\"keywords\":[\"AlwaysOn\",\"Availability groups\",\"health monitoring\",\"lease timeout\",\"SQL Server\",\"SQL Server 2012 SP3\",\"SQL Server 2014 SP2\",\"SQL Server 2016\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/\",\"name\":\"SQL Server AlwaysOn: new services packs and new diagnostic capabilities\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.jpg\",\"datePublished\":\"2016-07-18T16:24:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.jpg\",\"width\":1024,\"height\":94},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server AlwaysOn: new services packs and new diagnostic capabilities\"}]},{\"@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 AlwaysOn: new services packs and new diagnostic capabilities","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-alwayson-new-services-packs-and-new-diagnostic-capabilities\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server AlwaysOn: new services packs and new diagnostic capabilities","og_description":"As you certainly know, the SQL Server 2014 SP2 has been released by Microsoft with some interesting improvements that concern SQL Server AlwaysOn and availability groups feature. In fact, all of\u00a0them are also\u00a0included into\u00a0SQL Server 2012 SP3 and SQL Server 2016 (update 24.09.2016: not yet released with SQL Server 2016). Among all fixes and improvements […]","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/","og_site_name":"dbi Blog","article_published_time":"2016-07-18T16:24:13+00:00","og_image":[{"width":1024,"height":94,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.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-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/"},"author":{"name":"Microsoft Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"headline":"SQL Server AlwaysOn: new services packs and new diagnostic capabilities","datePublished":"2016-07-18T16:24:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/"},"wordCount":927,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.jpg","keywords":["AlwaysOn","Availability groups","health monitoring","lease timeout","SQL Server","SQL Server 2012 SP3","SQL Server 2014 SP2","SQL Server 2016"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/","name":"SQL Server AlwaysOn: new services packs and new diagnostic capabilities","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.jpg","datePublished":"2016-07-18T16:24:13+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bfab48333280d616e1170e7369df90a4"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/blog-101-AG-2014-SP2-lease-timeout-issue-e1468863934207-1.jpg","width":1024,"height":94},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-alwayson-new-services-packs-and-new-diagnostic-capabilities\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server AlwaysOn: new services packs and new diagnostic capabilities"}]},{"@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\/8580","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=8580"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8580\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8584"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8580"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}