dbcc opentran will tell for oldest open transaction.

look for last_batch and status

then runn dbcc inputbuffer(spid)

to see whats it running.