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.
Advantages of using the Query Store
1. Full-text query search:
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.
2. Top executing queries overview:
Using the Query Store catalog views, it is possible to get the top executing queries for further analysis:
3. Query execution time overview:
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.
Further reading:
- Monitoring performance by using the Query Store
- Query Store Catalog Views documentation
- To get started today by creating an Azure SQL Data Warehouse
Request a demo to speak with one of our engineers.