We have several tables that recently became locked but we cannot determine where the locks are coming from or why. When we try to truncate the tables and insert new data, the table truncation never completes because of the locks.
When we try to truncate the tables,
sys.dm_pdw_exec_requests shows these transactions as having a
status of "Suspended".
sys.dm_pdw_waits shows them as being in a
state of "Queued" with a
priority of "8". Does anyone know what these values mean? We haven't found any further documentation on them.
The reason all of this matters to us is that we have a pipeline set up in Data Factory that copies data to these tables in an Azure Synapse DB. These copy jobs recently started failing because the jobs are set up to first truncate the data in these tables before inserting new data.
We also saw this post (which is similar to our situation):
However, we don't know if the responses in that post apply to our situation or if a version update would resolve our issue.
Sorry this doesn't answer my question. When I see transactions in
sys.dm_pdw_waitsas being in a
stateof "Queued" with a
priorityof "8", what does that mean? I haven't found any documentation that explains what the different states or priorities mean.