How many queries and slots are running in my Azure SQL Data Warehouse?

Azure SQL Data Warehouse allows you to manage your workload using resource classes and concurrency slots for query execution. In the previous blog, Checking for Queued Queries, we showed you how to check to see if your query was queued and awaiting execution. That’s great to know why your query hasn’t started executing yet but…


Checking for queued queries in Azure SQL Data Warehouse

Azure SQL Data Warehouse manages query workload through a combination of concurrent query execution slots and resources classes. The SQL Data Warehouse workload manager enables you to manage your workload within your data warehouse that are contending for system resources. SQL Data Warehouse defines a set of concurrency slots for query execution. The system manages…