Watch this video on YouTube
I want to query a DMV which returns information about currently-running transactions for the instance of SQL Server. Which DMV should I use?