Labels

ASP.NET (1) Data Model (1) Django (1) MDX (15) Python (3) Redshift (3) SSAS (15) SSRS (3) T-SQL (29)

Monday, 18 June 2012

Active requests in MS SQL Database

The below query helps user to determine the active requests in MS SQL Server:

SELECT SQL_handle, * from sys.dm_exec_requests
SELECT
*  FROM  sys.dm_exec_sql_text(0x020000009D72DA2080C94ACE2F4DF4A9452887663FF9A16D)-- Use SQL_Handle values

No comments:

Post a Comment