You have a SQL pool in Azure Synapse. You discover that some queries fail or take a long time to complete. You need to monitor for transactions that have rolled back. Which dynamic management view sho

The correct answer is A. sys.dm_pdw_nodes_tran_database_transactions. You can use Dynamic Management Views (DMVs) to monitor your workload including investigating query execution in SQL pool. If your queries are failing or taking a long time to proceed, you can check and monitor if you have any transactions rolling back. --Monitor rollback SUM(CASE

Submitted by naveen.iyer· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

You have a SQL pool in Azure Synapse. You discover that some queries fail or take a long time to complete. You need to monitor for transactions that have rolled back. Which dynamic management view should you query?

Options

Asys.dm_pdw_nodes_tran_database_transactions
Bsys.dm_pdw_waits
Csys.dm_pdw_request_steps
Dsys.dm_pdw_exec_sessions
Epdw_node_id,

How the community answered

(43 responses)

A
84% (36)
B
9% (4)
C
2% (1)
E
5% (2)

Explanation

You can use Dynamic Management Views (DMVs) to monitor your workload including investigating query execution in SQL pool. If your queries are failing or taking a long time to proceed, you can check and monitor if you have any transactions rolling back. --Monitor rollback SUM(CASE WHEN t.database_transaction_next_undo_lsn IS NOT NULL THEN 1 ELSE 0 END), FROM sys.dm_pdw_nodes_tran_database_transactions t JOIN sys.dm_pdw_nodes nod ON t.pdw_node_id = nod.pdw_node_id GROUP BY t.pdw_node_id, nod.[type] https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-manage-monitor#monitor-transaction-log-rollback

Topics

#dynamic management views#transaction rollback#Synapse SQL pool#monitoring DMVs

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice