Share via

Killing a suspended request for a Synapse dedicated SQL pool

pmscorca 1,032 Reputation points
2024-03-13T16:29:19.71+00:00

Hi,

during the monitoring a Synapse dedicated SQL pool by using the sys.dm_pdw_exec_requests DMV I've noticed some requests in suspended status: is it possible to kill such requests (and how) or is it better to wait?

Thanks

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.
5,245 questions
0 comments
Accepted answer
  1. Nandan Hegde 34,426 Reputation points MVP
    2024-03-14T03:27:34.0866667+00:00

    Yes, you can kill the requests based on KILL SessionId

    Similar thread :

    https://learn.microsoft.com/en-us/answers/questions/77884/how-to-cancel-a-synapse-on-demand-query

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.