August 1, 2010

SQL SERVER: Find executing queries

Recently my company owner reported that SQL SERVER is running slow. I searched for it and get following T-SQL query. SQL SERVER provides dynamic views, which contains current information about all details.
SELECT OBJECT_NAME(ObjectID) as ObjectName,
  DB_NAME(database_ID) as dbname,
  Blocking_session_ID as BlockingSessionID,  
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st
It will give us details like about running SQL Objects, with Database name:
Reference : Tejas Shah

No comments:

Post a Comment