Watch this video on YouTube
Which DMV returns information about each request that is executing right now in SQL Server?