{"id":5400,"date":"2026-11-15T19:06:25","date_gmt":"2026-11-16T03:06:25","guid":{"rendered":"https:\/\/www.sqlskills.com\/blogs\/paul\/?p=5400"},"modified":"2026-11-15T19:16:52","modified_gmt":"2026-11-16T03:16:52","slug":"fgcb_add_remove-latch-investigation-demo","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/","title":{"rendered":"FGCB_ADD_REMOVE Latch Investigation Demo"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"5400\" class=\"elementor elementor-5400\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2811963 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2811963\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6a712da\" data-id=\"6a712da\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e297e1c elementor-widget elementor-widget-text-editor\" data-id=\"e297e1c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: justify;\">During the PASS Summit last week in Seattle I made a deal with my precon attendees that I&#8217;d record a couple of the demos in exchange for more time for questions and only running over ten minutes &#8211; sooooo many fantastic questions that took us down rabbit-holes into the internals!<\/p><p style=\"text-align: justify;\">As promised, here&#8217;s the first one.<\/p><p style=\"text-align: justify;\"><a href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-5401 size-large aligncenter\" src=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot-1024x532.jpg\" alt=\"\" width=\"640\" height=\"333\" srcset=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot-1024x532.jpg 1024w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot-300x156.jpg 300w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot-768x399.jpg 768w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot-1536x798.jpg 1536w, https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot.jpg 1746w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p><p style=\"text-align: justify;\">It deals with investigating the <em>FGCB_ADD_REMOVE<\/em> latch using an XEvent session to watch the latches being acquired and dropped, showing the wasted time on the waiting threads and how to see which file in which database has the incorrect auto-growth setting.<\/p><p>Here are the pertinent links:<\/p><ul><li>Demo video <a href=\"https:\/\/www.sqlskills.com\/insidercontent\/202611\/november2026insidervideo.mp4\" target=\"_blank\" rel=\"noopener\">MP4<\/a>\u00a0(about 8 minutes, 100MB)<\/li><li>Demo code <a href=\"https:\/\/www.sqlskills.com\/insidercontent\/202611\/insider202611democode.zip\" target=\"_blank\" rel=\"noopener\">zip file<\/a><\/li><li><a href=\"https:\/\/www.sqlskills.com\/help\/latches\/fgcb_add_remove\/\" target=\"_blank\" rel=\"noopener\"><em>FGCB_ADD_REMOVE<\/em> entry<\/a> in my waits\/latches library<\/li><li>2021 <a href=\"https:\/\/sqlperformance.com\/2021\/06\/sql-performance\/fgcb-add-remove-latch\" target=\"_blank\" rel=\"noopener\">article<\/a> from the old SQLPerformance.com I wrote with more background<\/li><\/ul><p>Enjoy!<\/p><p>(PS It&#8217;s also doubling as the video demo for this week&#8217;s <a href=\"https:\/\/www.sqlskills.com\/newsletter\/\" target=\"_blank\" rel=\"noopener\">SQLskills Insider<\/a> newsletter)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>During the PASS Summit last week in Seattle I made a deal with my precon attendees that I&#8217;d record a couple of the demos in exchange for more time for questions and only running over ten minutes &#8211; sooooo many fantastic questions that took us down rabbit-holes into the internals! As promised, here&#8217;s the first [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,101],"tags":[],"class_list":["post-5400","post","type-post","status-publish","format-standard","hentry","category-latches","category-wait-stats"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>FGCB_ADD_REMOVE Latch Investigation Demo - Paul S. Randal<\/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.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FGCB_ADD_REMOVE Latch Investigation Demo - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"During the PASS Summit last week in Seattle I made a deal with my precon attendees that I&#8217;d record a couple of the demos in exchange for more time for questions and only running over ten minutes &#8211; sooooo many fantastic questions that took us down rabbit-holes into the internals! As promised, here&#8217;s the first [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-16T03:06:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-16T03:16:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1746\" \/>\n\t<meta property=\"og:image:height\" content=\"907\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/\"},\"author\":{\"name\":\"Paul Randal\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/#\\\/schema\\\/person\\\/ffcec826c18782e1e0adf173826a7fce\"},\"headline\":\"FGCB_ADD_REMOVE Latch Investigation Demo\",\"datePublished\":\"2026-11-16T03:06:25+00:00\",\"dateModified\":\"2026-11-16T03:16:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/\"},\"wordCount\":159,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/screenshot-1024x532.jpg\",\"articleSection\":[\"Latches\",\"Wait Stats\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/\",\"name\":\"FGCB_ADD_REMOVE Latch Investigation Demo - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/screenshot-1024x532.jpg\",\"datePublished\":\"2026-11-16T03:06:25+00:00\",\"dateModified\":\"2026-11-16T03:16:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/#\\\/schema\\\/person\\\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/screenshot.jpg\",\"contentUrl\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/screenshot.jpg\",\"width\":1746,\"height\":907},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/fgcb_add_remove-latch-investigation-demo\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FGCB_ADD_REMOVE Latch Investigation Demo\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/#\\\/schema\\\/person\\\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/paul\"],\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/paul\\\/author\\\/paul\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"FGCB_ADD_REMOVE Latch Investigation Demo - Paul S. Randal","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.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/","og_locale":"en_US","og_type":"article","og_title":"FGCB_ADD_REMOVE Latch Investigation Demo - Paul S. Randal","og_description":"During the PASS Summit last week in Seattle I made a deal with my precon attendees that I&#8217;d record a couple of the demos in exchange for more time for questions and only running over ten minutes &#8211; sooooo many fantastic questions that took us down rabbit-holes into the internals! As promised, here&#8217;s the first [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/","og_site_name":"Paul S. Randal","article_published_time":"2026-11-16T03:06:25+00:00","article_modified_time":"2026-11-16T03:16:52+00:00","og_image":[{"width":1746,"height":907,"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot.jpg","type":"image\/jpeg"}],"author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/"},"author":{"name":"Paul Randal","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"headline":"FGCB_ADD_REMOVE Latch Investigation Demo","datePublished":"2026-11-16T03:06:25+00:00","dateModified":"2026-11-16T03:16:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/"},"wordCount":159,"commentCount":0,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot-1024x532.jpg","articleSection":["Latches","Wait Stats"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/","name":"FGCB_ADD_REMOVE Latch Investigation Demo - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot-1024x532.jpg","datePublished":"2026-11-16T03:06:25+00:00","dateModified":"2026-11-16T03:16:52+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/#primaryimage","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot.jpg","contentUrl":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-content\/uploads\/2026\/11\/screenshot.jpg","width":1746,"height":907},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/fgcb_add_remove-latch-investigation-demo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"FGCB_ADD_REMOVE Latch Investigation Demo"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/5400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=5400"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/5400\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=5400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=5400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=5400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}