{"id":44012,"date":"2022-08-18T08:00:00","date_gmt":"2022-08-18T15:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=44012"},"modified":"2024-04-19T10:39:24","modified_gmt":"2024-04-19T17:39:24","slug":"query-store-is-enabled-by-default-in-sql-server-2022","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/","title":{"rendered":"Query Store is enabled by default in SQL Server 2022"},"content":{"rendered":"\n<p><em>Part of the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/tag\/sql-server-2022-blogging-series\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server 2022 blog series<\/a>.<\/em><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/monitoring-performance-by-using-the-query-store?view=sql-server-ver16\">Query Store<\/a> is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database workloads.<\/p>\n\n\n\n<p>The Query Store feature first became available in SQL Server 2016 and provides the ability for database administrators (DBAs) to gain insights on query plan choice and the impact these choices have on SQL Server performance.<\/p>\n\n\n\n<p>In <a href=\"https:\/\/info.microsoft.com\/ww-landing-sql-server-2022.html\">SQL Server 2022<\/a>, Query Store is now enabled by default for all newly created SQL Server databases to help customers better track performance history, troubleshoot query plan\u2013related issues, and enable new query processor capabilities that we will introduce in the subsequent <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/product\/sql-server-2022\/\" target=\"_blank\" rel=\"noreferrer noopener\">SQL Server 2022 blog series<\/a>.<\/p>\n\n\n\n<p>When enabled, Query Store asynchronously captures a history of queries, plans, and runtime statistics, and persists this data at the database scope. This means that when you migrate your databases to another version of SQL Server, migrate to different hardware, or even migrate your databases to the cloud\u2014you can examine the performance difference down to the query plan level.<\/p>\n\n\n\n<p>Query Store accomplishes this by separating the performance data by time windows so DBAs can identify usage patterns and understand when query plan changes happened on the server.<\/p>\n\n\n\n<p>If an application starts having a performance issue which can occur in a number of scenarios such as high usage, post-migration, and especially when data distributions change\u2014Query Store provides a method to <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/optimized-plan-forcing-query-store?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">force which plan a query will use<\/a>. The ability to control which plans a query will use makes it much easier to respond to errant query plans and provides database administrators with the assurance they can upgrade to later versions of SQL Server, change database compatibility levels, and confidently migrate database applications to the cloud. &nbsp;<\/p>\n\n\n\n<p>For all these scenarios, Query Store gives DBAs the confidence that they can easily monitor their database application\u2019s performance and quickly respond to performance issues when needed.<\/p>\n\n\n\n<p>Query Store is available for SQL Server, Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. In Azure SQL database, Query Store is referred to as <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/query-performance-insight-use?view=azuresql\" target=\"_blank\" rel=\"noreferrer noopener\">Query Performance Insights<\/a> and is managed on the Query Performance Insight navigation blade.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"query-performance-insights-in-azure-sql-database\">Query Performance Insights in Azure SQL Database<\/h2>\n\n\n\n<p>While it is a new scenario to have Query Store enabled by default for SQL Server, Query Store has be enabled by default for <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/sql-database-paas-overview?view=azuresql\" target=\"_blank\" rel=\"noreferrer noopener\">Azure SQL Database<\/a> (including <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/database\/elastic-pool-overview?view=azuresql\" target=\"_blank\" rel=\"noreferrer noopener\">elastic pools<\/a>) and <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/azure-sql\/managed-instance\/sql-managed-instance-paas-overview?view=azuresql\" target=\"_blank\" rel=\"noreferrer noopener\">Azure SQL Managed Instance<\/a> databases for some time now and this capability has been extended to SQL Server 2022.<\/p>\n\n\n\n<p>Query Store has been a popular feature since it was first made available in SQL Server 2016, and now in SQL Server 2022 we are leveraging Query Store\u2019s ability to persist query plan history and health to enable new capabilities.<\/p>\n\n\n\n<p>Query Store in SQL Server 2022 extends the ability of the query processor by enabling features such as Query Store hints, cardinality estimation (CE) feedback, degree of parallelism (DOP) feedback, memory grant feedback (MGF) persistence, and optimized plan forcing.<\/p>\n\n\n\n<p>Query Store\u2019s ability to asynchronously make a record of your database application\u2019s performance data enables these new capabilities in SQL Server 2022.<\/p>\n\n\n\n<p>While we are enabling Query Store by default for all newly created databases in SQL Server 2022, it is important to note that for all databases that have been restored from other SQL Server instances and for those databases that are upgraded from an in-place upgrade to SQL Server 2022, these databases will retain the previous Query Store settings\u2014whether they had Query Store enabled or not.<\/p>\n\n\n\n<p>As a post-migration step, for databases that are restored from previous SQL Server instances, it is recommended to <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/monitoring-performance-by-using-the-query-store?view=sql-server-ver15#Enabling\" target=\"_blank\" rel=\"noreferrer noopener\">enable Query Store<\/a> and separately evaluate the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/alter-database-transact-sql-compatibility-level?view=sql-server-ver15#differences-between-compatibility-levels\" target=\"_blank\" rel=\"noreferrer noopener\">database compatibility level<\/a> settings as some Intelligent <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/intelligent-query-processing-details?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Query Processing features<\/a> are enabled by the compatibility level setting.<\/p>\n\n\n\n<p><strong>Note: <\/strong>For optimal SQL Server performance and migration health, it is recommended to closely follow the recommendations provided in the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/post-migration-validation-and-optimization-guide?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">post-migration validation and optimization guide<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"query-store-overhead\">Query Store overhead<\/h2>\n\n\n\n<p>As mentioned, Query Store has been available in Azure SQL Database and Azure SQL Managed Instance since 2016; additionally, we have improved Query Store performance in the last several releases of SQL Server with many improvements being surfaced through <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/latest-updates-for-microsoft-sql-server?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">cumulative updates<\/a> in SQL Server 2019.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"query-store-improvements-introduced-via-cumulative-updates\">Query Store improvements introduced via cumulative updates<\/h3>\n\n\n\n<p>Microsoft has improved ad-hoc workloads with Query Store with several cumulative updates in SQL Server 2019.<\/p>\n\n\n\n<p>The most relevant cumulative updates that influence Query Store health are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/topic\/kb5000642-cumulative-update-9-for-sql-server-2019-97ad5c3e-e002-4b6d-b566-698bf70ca44a?msclkid=d9ec037caed411ecb09f72957d2a8dc8#bkmk_13749461\"><strong>KB5000642\u2014Cumulative Update 9 for SQL Server 2019<\/strong><\/a>: Fixes Query Store scalability improvement for ad-hoc workloads.<\/li>\n\n\n\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/topic\/kb4577194-cumulative-update-8-for-sql-server-2019-ed7f79d9-a3f0-a5c2-0bef-d0b7961d2d72#bkmk_13663200\"><strong>KB4577194\u2014Cumulative Update 8 for SQL Server 2019<\/strong><\/a>: Query Store scalability improvement for ad-hoc workloads. Query Store now imposes internal limits to the amount of memory it can use and automatically changes the operation mode to <code>READ_ONLY<\/code> until enough memory has been returned to the Database Engine, preventing performance issues.<\/li>\n\n\n\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/topic\/kb4563110-cumulative-update-6-for-sql-server-2019-757cb0fa-56ff-c6e4-d56b-a695b7fdc64e#bkmk_13516056\"><strong>KB4563110\u2014Cumulative Update 6 for SQL Server 2019<\/strong><\/a>: This improvement can force the Query Store option to be turned off by specifying the additional option <code>FORCED <\/code>in the <code>ALTER DB <\/code>command. The <code>FORCED<\/code> option allows you to turn off Query Store immediately by aborting all background tasks. <code>ALTER DATABASE {0} SET QUERY_STORE = OFF (FORCED)<\/code><\/li>\n<\/ul>\n\n\n\n<p><strong>Note:<\/strong> It is always recommended to evaluate the latest cumulative updates for the release of SQL Server your organization is maintaining for the best performance and stability of your database application environment.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"query-store-setting-improvements\">Query Store setting improvements<\/h3>\n\n\n\n<p>In addition to the stability improvements, we introduced via the cumulative updates in SQL Server 2019, the Query Store default behavior has been refined to reduce the volume of the captured Query Store details while increasing the amount of Query Store history that can be retained.<\/p>\n\n\n\n<p>The setting changes that were introduced in SQL Server 2019 have been carried forward and will improve the performance of the Query Store behavior while still optimizing the Query Store\u2019s ability to serve both as a \u201cflight data recorder,\u201d but to also enable the query processor\u2019s ability to leverage new capabilities in SQL Server 2022.<\/p>\n\n\n\n<p>To improve the performance of the Query Store settings, the capture mode has changed from ALL to AUTO, and the max size (MB) has changed from 100 MB to 1024 MB.<\/p>\n\n\n\n<p>Under the AUTO capture mode setting, we now capture Query Store details when any of the following thresholds are hit:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1 second = any compilation<\/li>\n\n\n\n<li>100 milliseconds = execution CPU time<\/li>\n\n\n\n<li>30 executions = execution count<\/li>\n<\/ul>\n\n\n\n<p>These settings help further reduce any impact Query Store could have on SQL Server, while still ensuring that the critical data is captured for troubleshooting and providing the ability to enable new capabilities in SQL Server 2022.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"custom-capture-policies\">Custom capture policies<\/h3>\n\n\n\n<p>In order to take advantage of certain SQL Server 2022 capabilities, it is necessary to have Query Store enabled by default.<\/p>\n\n\n\n<p>If there is still any concern about the overhead Query Store may introduce, database administrators can leverage <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/best-practice-with-the-query-store?view=sql-server-ver16#Configure\" target=\"_blank\" rel=\"noreferrer noopener\">custom capture policies<\/a> to further tune the Query Store capture behavior.<\/p>\n\n\n\n<p>Custom capture policies are available to help further tune Query Store captures. Custom capture policies can be used to be more selective about which queries and query details are captured. For example, an administrator may choose to capture only the most expensive queries, repeated queries, or queries that have a high level of compute overhead.<\/p>\n\n\n\n<p>Custom capture policies can help Query Store capture the most important queries in your workload.<\/p>\n\n\n\n<p>Please see the example <code>ALTER DATABASE<\/code> script below that would enable a custom capture policy for Query Store:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nALTER DATABASE &#x5B;QueryStoreDB]\n SET QUERY_STORE = ON\n (\n OPERATION_MODE = READ_WRITE,\n CLEANUP_POLICY = ( STALE_QUERY_THRESHOLD_DAYS = 90 ),\n DATA_FLUSH_INTERVAL_SECONDS = 900,\n MAX_STORAGE_SIZE_MB = 1000,\n INTERVAL_LENGTH_MINUTES = 60,\n SIZE_BASED_CLEANUP_MODE = AUTO,\n MAX_PLANS_PER_QUERY = 200,\n WAIT_STATS_CAPTURE_MODE = ON,\n QUERY_CAPTURE_MODE = CUSTOM,\n   QUERY_CAPTURE_POLICY = (\n   STALE_CAPTURE_POLICY_THRESHOLD = 24 HOURS,\n   EXECUTION_COUNT = 30,\n   TOTAL_COMPILE_CPU_TIME_MS = 1000,\n   TOTAL_EXECUTION_CPU_TIME_MS = 100\n   ) );\n<\/pre><\/div>\n\n\n<p><strong>Note:<\/strong> Except for <code>STALE_CAPTURE_POLICY_THRESHOLD<\/code>, these options define the OR conditions that need to happen for queries to be captured in the defined Stale Capture Policy Threshold value.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nQUERY_CAPTURE_MODE = CUSTOM,\n QUERY_CAPTURE_POLICY = ( \nSTALE_CAPTURE_POLICY_THRESHOLD = 24 HOURS, \nEXECUTION_COUNT = 30, \nTOTAL_COMPILE_CPU_TIME_MS = 1000, \nTOTAL_EXECUTION_CPU_TIME_MS = 100 \n)\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"summary\">Summary<\/h2>\n\n\n\n<p>Query Store in SQL Server has been a popular feature since the SQL Server 2016 release to provide the ability for Query Store to act as a \u201cflight data recorder\u201d for SQL Server. Query Store accomplishes this by collecting information about query performance over time. As a result, Query Store has a strong capability to reduce the time it takes for a database administrator to respond to critical performance events and help ease the migration of databases between on-premises systems (hardware and SQL Server releases) as well as migrate database applications to the cloud.<\/p>\n\n\n\n<p>DBAs use Query Store in many of the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/query-store-usage-scenarios?redirectedfrom=MSDN&amp;view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">following scenarios<\/a> to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ensure the health of database upgrades and migrations.<\/li>\n\n\n\n<li>Discover and address application performance regressions.<\/li>\n\n\n\n<li>Tune in the most expensive queries based on resource consumption (elapsed time, compute overhead, memory, I\/O, and more).<\/li>\n\n\n\n<li>Maintain performance between database compatibility level upgrades.<\/li>\n\n\n\n<li>And many other <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/query-store-usage-scenarios?redirectedfrom=MSDN&amp;view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Query Store Usage Scenarios<\/a>.<\/li>\n<\/ul>\n\n\n\n<p>SQL Server 2022 now supports the enabled by default behavior and introduces the ability for the Query Processor to be able to leverage the historical performance data.<\/p>\n\n\n\n<p>This capability extends Query Store\u2019s power beyond troubleshooting and migration scenarios, and to the next level of intelligent query processing behavior in SQL Server.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"next-steps\">Next steps<\/h2>\n\n\n\n<p><a href=\"https:\/\/aka.ms\/getsqlserver2022\">Download the latest release<\/a> of SQL Server 2022 if you haven\u2019t already done so and check out the SQL Server 2022 Overview and What\u2019s New references. There are many new features and improved functionality being added to this release.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"learn-more\">Learn more<\/h2>\n\n\n\n<p>For more information and to get started, check out the following references:<\/p>\n\n\n\n<p>Read <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/what-s-new-in-sql-server-2022?view=sql-server-ver16\">What\u2019s New in SQL Server 2022<\/a>.<\/p>\n\n\n\n<p>Additional useful resources:<\/p>\n\n\n\n<div class=\"wp-block-group is-layout-flow wp-block-group-is-layout-flow\">\n<div class=\"wp-block-group is-layout-flow wp-block-group-is-layout-flow\">\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/monitoring-performance-by-using-the-query-store?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Monitor performance by using the Query Store<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/best-practice-with-the-query-store?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Best practices with Query Store<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/performance\/query-store-usage-scenarios?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Query Store Usage Scenarios<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/alter-database-transact-sql-compatibility-level?view=sql-server-ver16#differences-between-compatibility-levels\" target=\"_blank\" rel=\"noreferrer noopener\">Differences between Compatibility Levels<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/compatibility-certification?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Compatibility certification<\/a>.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In SQL Server 2022, Query Store is now enabled by default for all newly created SQL Server databases.<\/p>\n","protected":false},"author":6051,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"post_tag":[5278],"product":[5227,3645],"content-type":[2448],"topic":[],"coauthors":[5093],"class_list":["post-44012","post","type-post","status-publish","format-standard","hentry","tag-sql-server-2022-blogging-series","product-sql","product-sql-server-2022","content-type-updates","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-6-1593580457-144","review-flag-8-1593580467-480","review-flag-9-1593580472-173","review-flag-alway-1593580309-407","review-flag-lever-1593580264-545","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Query Store is enabled by default in SQL Server 2022 - Microsoft SQL Server Blog<\/title>\n<meta name=\"description\" content=\"In SQL Server 2022, Query Store is enabled by default to help database administrators (DBAs) gain insights on query plan choice and performance impact.\" \/>\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.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Query Store is enabled by default in SQL Server 2022 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"In SQL Server 2022, Query Store is enabled by default to help database administrators (DBAs) gain insights on query plan choice and performance impact.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-18T15:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-19T17:39:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"David Pless\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"David Pless\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/david-pless\/\",\"@type\":\"Person\",\"@name\":\"David Pless\"}],\"headline\":\"Query Store is enabled by default in SQL Server 2022\",\"datePublished\":\"2022-08-18T15:00:00+00:00\",\"dateModified\":\"2024-04-19T17:39:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/\"},\"wordCount\":1520,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"keywords\":[\"SQL Server 2022 Blogging Series\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/\",\"name\":\"Query Store is enabled by default in SQL Server 2022 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2022-08-18T15:00:00+00:00\",\"dateModified\":\"2024-04-19T17:39:24+00:00\",\"description\":\"In SQL Server 2022, Query Store is enabled by default to help database administrators (DBAs) gain insights on query plan choice and performance impact.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Query Store is enabled by default in SQL Server 2022\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Query Store is enabled by default in SQL Server 2022 - Microsoft SQL Server Blog","description":"In SQL Server 2022, Query Store is enabled by default to help database administrators (DBAs) gain insights on query plan choice and performance impact.","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.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/","og_locale":"en_US","og_type":"article","og_title":"Query Store is enabled by default in SQL Server 2022 - Microsoft SQL Server Blog","og_description":"In SQL Server 2022, Query Store is enabled by default to help database administrators (DBAs) gain insights on query plan choice and performance impact.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2022-08-18T15:00:00+00:00","article_modified_time":"2024-04-19T17:39:24+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"David Pless","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"David Pless","Est. reading time":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/david-pless\/","@type":"Person","@name":"David Pless"}],"headline":"Query Store is enabled by default in SQL Server 2022","datePublished":"2022-08-18T15:00:00+00:00","dateModified":"2024-04-19T17:39:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/"},"wordCount":1520,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"keywords":["SQL Server 2022 Blogging Series"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/","name":"Query Store is enabled by default in SQL Server 2022 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2022-08-18T15:00:00+00:00","dateModified":"2024-04-19T17:39:24+00:00","description":"In SQL Server 2022, Query Store is enabled by default to help database administrators (DBAs) gain insights on query plan choice and performance impact.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/08\/18\/query-store-is-enabled-by-default-in-sql-server-2022\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Query Store is enabled by default in SQL Server 2022"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/44012"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/6051"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=44012"}],"version-history":[{"count":2,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/44012\/revisions"}],"predecessor-version":[{"id":50687,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/44012\/revisions\/50687"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=44012"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=44012"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=44012"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=44012"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=44012"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=44012"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}