Since the recent preview, Query Store raised great interest among users as an effective solution to provide insight on query performance. Microsoft announced the general availability of Query Store for Azure SQL Data Warehouse worldwide.
When monitoring a data warehouse, Query Store captures query history, separates the data by time slots and provides an overview of the database usage patterns.
The sys.query_store_query and sys.query_store_query_text catalog views provide the full query text executed against the data warehouse over the last 7 days.
Using the Query Store catalog views, it is possible to get the top executing queries for further analysis:
Query Store collects the runtime query statistics that allows focusing on the queries with variance in execution which could be helpful during a high workload.
Query Store is now available in all regions for all generations of SQL Data Warehouse at no additional charges. Enabling Query Store is as easy as running the ALTER DATABASE <database name> SET QUERY_STORE = ON; command.
Request a demo to speak with one of our engineers.
