View Active Requests

To see currently executing requests on the SQL Server instance, you can query the sys.dm_exec_requests dynamic management view.

SELECT * FROM sys.dm_exec_requests;