how to track which transactions are hung on a SQL server

Question

i am developing a monitoring application which determines which transactions on the SQl server are hung. how can i know which applications are hung ? is there some particular API for this ?

Answer 1

You should have a look at Transaction Related Dynamic Management Views and Functions (Transact-SQL), notably sys.dm_tran_active_transactions