Get Active Queries In SQL Server 2008

In this article I tell you about how to get list of active queries in SQL Server.
  • 1922

In this article I tell you about how to get list of active queries in SQL Server.

To get active queries using T-SQL, run following code snippet:

SELECT *

FROM sys.dm_exec_requests

CROSS APPLY sys.dm_exec_sql_text(sql_handle)

This code will generate following result:

ActiveQueries.jpg

© 2019 DotNetHeaven. All rights reserved.