Has my Azure Synapse dedicated SQL Pool locked itself up?

iw 101 Reputation points
2022-04-22T00:00:05.397+00:00

I have a query in a synapse dedicated sql pool that has been suspended for over an hour. From what I know, a suspended query indicates that the query is waiting for a concurrency spot.
I have a process that was inserting data into a replicated table (lets say its called MyTable). The very next query was to select all records from MyTable but that query is now suspended.
If have run the following query:

SELECT	*  
FROM	sys.dm_pdw_resource_waits  

which produces:

195351-image.png

Why would I still be having queued requests when there are no concurrency spots being used?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,668 questions
{count} votes