{"id":1739,"date":"2019-01-31T00:00:00","date_gmt":"2019-01-31T00:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/announcing-the-general-availability-of-query-store-for-azure-sql-data-warehouse"},"modified":"2025-06-12T05:36:03","modified_gmt":"2025-06-12T12:36:03","slug":"announcing-the-general-availability-of-query-store-for-azure-sql-data-warehouse","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/announcing-the-general-availability-of-query-store-for-azure-sql-data-warehouse\/","title":{"rendered":"Announcing the general availability of Query Store for Azure SQL Data Warehouse"},"content":{"rendered":"\n

Since our preview announcement<\/a>, hundreds of customers have been enabling Query Store<\/a> to provide insight on query performance. We\u2019re excited to share the general availability of Query Store worldwide for Azure SQL Data Warehouse<\/a>.<\/p>\n\n\n\n

Query Store automatically captures a history of queries, plans, and runtime statistics and retains them for your review when monitoring your data warehouse. Query Store separates data by time windows so you can see database usage patterns and understand when plan changes happen.<\/p>\n\n\n\n

Top three reasons to use Query Store right now<\/h2>\n\n\n\n

1. Find the full text of any query<\/strong>: Using the sys.query_store_query<\/a> and sys.query_store_query_text<\/a> catalog views, you can see the full text of queries executed against your data warehouse over the last 7 days.<\/p>\n\n\n

\nSELECT\n     q.query_id\n     , t.query_sql_text\nFROM\n     sys.query_store_query q\n     JOIN sys.query_store_query_text t ON q.query_text_id = t.query_\n<\/pre><\/div>\n\n\n
2. Finding your top executing queries<\/strong>: Query Store tracks all query executions for your review. On a busy data warehouse, you may have thousands or millions of queries executed daily. Using the Query Store catalog views, you can get the top executing queries for further analysis:<\/p>\n\n\n
\nSELECT TOP 10\n       q.query_id                    [query_id]\n       , t.query_sql_text            [command]\n       , SUM(rs.count_executions)    [execution_count]\nFROM\n       sys.query_store_query q\n       JOIN sys.query_store_query_text t ON q.query_text_id = t.query_text_id\n       JOIN sys.query_store_plan p ON p.query_id = q.query_id\n       JOIN sys.query_store_runtime_stats rs ON rs.plan_id = p.plan_id\nGROUP BY\n       q.query_id , t.query_sql_text ORDER BY 3 DESC;\n<\/pre><\/div>\n\n\n
3. Finding the execution times for a query<\/strong>: Query also gathers runtime query statistics to help you focus on queries with variance in execution. The variance could be for a variety of reasons such as loading a bunch of new data.<\/p>\n\n\n
\nSELECT\n       q.query_id               [query_id]\n       , t.query_sql_text       [command]\n       , rs.avg_duration        [avg_duration]\n       , rs.min_duration        [min_duration]\n       , rs.max_duration        [max_duration]\nFROM\n       sys.query_store_query q\n       JOIN sys.query_store_query_text t ON q.query_text_id = t.query_text_id\n       JOIN sys.query_store_plan p ON p.query_id = q.query_id\n       JOIN sys.query_store_runtime_stats rs ON rs.plan_id = p.plan_id\nWHERE\n       q.query_id = 10\n       AND rs.avg_duration > 0;\n<\/pre><\/div>\n\n\n
Get started now<\/h2>\n\n\n\n
Query Store is available in all regions for all generations of SQL Data Warehouse with no additional charges. You can enable Query Store by running the ALTER DATABASE SET QUERY_STORE = ON; <\/code>command.<\/p>\n\n\n\n
To get started, you can read the monitoring performance by using the Query Store<\/a> overview topic. A complete list of supported operations can be found in the Query Store Catalog Views<\/a> documentation.<\/p>\n\n\n\n
Next steps<\/h2>\n\n\n\n
Azure SQL Data Warehouse continues to lead in the areas of security, compliance, privacy, and auditing. For more information, refer to the whitepaper, \u201cGuide to enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform,\u201d on Microsoft Trust Center<\/a>, or our documentation, \u201cSecure a database in SQL Data Warehouse<\/a>.\u201d<\/p>\n\n\n\n