Query Store automatically captures a history of queries, plans, and runtime statistics and retains them for your review when monitoring your data warehouse. This feature enables you to gain insight on your query plan choice and performance—making troubleshooting simple and quick. Query Store separates data by time windows so you can see usage patterns and understand when query plan changes happened on a server.
Query Store is now available in all regions for all generations of Azure SQL Data Warehouse with no additional charges. To get started, you can read the monitoring performance by using the Query Store overview topic. A complete list of supported operations can be found in the Query Store Catalog Views documentation.
Learn more