title: Azure Synapse transaction stuck in queued state
body: <p>We have several tables living in an Azure Synapse DB that we need to truncate as part of a larger pipeline. But, starting very recently, whenever we try to truncate the tables, the transactions are unable to complete and get stuck in an eternal state of suspension.</p>
  <p><code>sys.dm_pdw_exec_requests</code> shows these transactions as having a <code>status</code> of &quot;Suspended&quot; while <code>sys.dm_pdw_waits</code> shows them as being in a <code>state</code> of &quot;Queued&quot; with a <code>priority</code> of &quot;8&quot;. Does anyone know what these values mean? We haven't found any further documentation on them. Any suggestions on particular queries that can be executed within Synapse that could provide more detail about the reason for these suspensions?</p>
  <p>The reason all of this matters to us is that we have a pipeline set up in Azure Data Factory that copies data to these tables. This pipeline is set up to first truncate the data in our tables before inserting new data. Because the truncation is eternally suspended, the copy jobs never complete and the pipeline fails.</p>