{"id":1025,"date":"2019-06-21T06:00:41","date_gmt":"2019-06-21T13:00:41","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=1025"},"modified":"2019-06-21T08:29:28","modified_gmt":"2019-06-21T15:29:28","slug":"important-query-store-fixes-summer-2019","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/","title":{"rendered":"Important Query Store Fixes – Summer 2019"},"content":{"rendered":"

In January I blogged about important Query Store fixes that were available in current CUs.\u00a0 Check my January post<\/a> for fixes through SQL Server 2016 SP2 CU5 and SQL Server 2017 CU13.<\/p>\n

I’m using this post to track Query Store fixes\/enhancements since those releases, so you can find updates here as additional CUs are released throughout the summer.<\/p>\n

SQL Server 2016 SP2 CU7<\/h2>\n

FIX: “Non-yielding Scheduler” occurs when you clean up in-memory runtime statistics of Query Store in SQL Server 2016<\/a><\/p>\n

I definitely<\/strong> recommend that you update to this CU if you are using Query Store with SQL Server 2016 SP2, especially<\/em> if you have an ad hoc or mixed workload.<\/p>\n

Remember that runtime statistics and some query information is stored in-memory<\/a>, and this CU addresses an issue with cleanup of the runtime statistics, based on the CLEANUP_POLICY and MAX_STORAGE_SIZE_MB.<\/p>\n

I have seen issues where the space used for Query Store exceeds the MAX_STORAGE_SIZE_MB settings, and this CU should help address that behavior.\u00a0 Again, it’s important to make sure your Query Store is sized appropriately, based on the type of workload you have (ad hoc will require more space) and how long you want to keep your data.\u00a0 While it’s nice to keep 30 days of data, in some scenarios that doesn’t fit within the 10GB “ideal” size for Query Store<\/a>.<\/p>\n

I don’t see this fix in a 2017 CU.<\/p>\n","protected":false},"excerpt":{"rendered":"

In January I blogged about important Query Store fixes that were available in current CUs.\u00a0 Check my January post for fixes through SQL Server 2016 SP2 CU5 and SQL Server 2017 CU13. I’m using this post to track Query Store fixes\/enhancements since those releases, so you can find updates here as additional CUs are released […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"yoast_head":"\nImportant Query Store Fixes - Summer 2019 - Erin Stellato<\/title>\n<meta name=\"description\" content=\"Additional query store fixes have been found in recent CUs for SQL Sever 2016 and SQL Server 2017, and you can find updates here.\" \/>\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\/erin\/important-query-store-fixes-summer-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Important Query Store Fixes - Summer 2019 - Erin Stellato\" \/>\n<meta property=\"og:description\" content=\"Additional query store fixes have been found in recent CUs for SQL Sever 2016 and SQL Server 2017, and you can find updates here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Erin Stellato\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-21T13:00:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-21T15:29:28+00:00\" \/>\n<meta name=\"author\" content=\"Erin Stellato\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Erin Stellato\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/\",\"name\":\"Important Query Store Fixes - Summer 2019 - Erin Stellato\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\"},\"datePublished\":\"2019-06-21T13:00:41+00:00\",\"dateModified\":\"2019-06-21T15:29:28+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\"},\"description\":\"Additional query store fixes have been found in recent CUs for SQL Sever 2016 and SQL Server 2017, and you can find updates here.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Important Query Store Fixes – Summer 2019\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/\",\"name\":\"Erin Stellato\",\"description\":\"The SQL Sequel\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158\",\"name\":\"Erin Stellato\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g\",\"caption\":\"Erin Stellato\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/erin\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Important Query Store Fixes - Summer 2019 - Erin Stellato","description":"Additional query store fixes have been found in recent CUs for SQL Sever 2016 and SQL Server 2017, and you can find updates here.","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\/erin\/important-query-store-fixes-summer-2019\/","og_locale":"en_US","og_type":"article","og_title":"Important Query Store Fixes - Summer 2019 - Erin Stellato","og_description":"Additional query store fixes have been found in recent CUs for SQL Sever 2016 and SQL Server 2017, and you can find updates here.","og_url":"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/","og_site_name":"Erin Stellato","article_published_time":"2019-06-21T13:00:41+00:00","article_modified_time":"2019-06-21T15:29:28+00:00","author":"Erin Stellato","twitter_misc":{"Written by":"Erin Stellato","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/","name":"Important Query Store Fixes - Summer 2019 - Erin Stellato","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website"},"datePublished":"2019-06-21T13:00:41+00:00","dateModified":"2019-06-21T15:29:28+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158"},"description":"Additional query store fixes have been found in recent CUs for SQL Sever 2016 and SQL Server 2017, and you can find updates here.","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/important-query-store-fixes-summer-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/erin\/"},{"@type":"ListItem","position":2,"name":"Important Query Store Fixes – Summer 2019"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/erin\/","name":"Erin Stellato","description":"The SQL Sequel","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/erin\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/76170223ffffa1df03fd9be5b66cb158","name":"Erin Stellato","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/erin\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c8b485bd54ea26b57e99f79b525f409?s=96&d=mm&r=g","caption":"Erin Stellato"},"sameAs":["http:\/\/3.209.169.194\/blogs\/erin"],"url":"https:\/\/www.sqlskills.com\/blogs\/erin\/author\/erin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/1025"}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/comments?post=1025"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/posts\/1025\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/media?parent=1025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/categories?post=1025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/erin\/wp-json\/wp\/v2\/tags?post=1025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}