1

Is there is any way to check blocked queries in Azure Data warehouse?? In my monitoring tool it's shows two blocked queries during morning session. I need to find which queries are blocking...

hiroki
  • 434
  • 2
  • 15
Sha
  • 73
  • 2
  • 7

1 Answers1

3

Try looking at the DMV sys.dm_pdw_waits. There is an example in this article, https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-manage-monitor/#monitor-waiting-queries.

Sonya Marshall
  • 506
  • 2
  • 4