What is SQL Server Executing Now?

When you want to verify what MS SQL Server is doing right now:

  • Open SSMS and connect to the desired SQL instance

  • Right-click the instance name → New Query

  • Copy and paste the code below on the right panel:

SELECT DB_NAME(database_id) [DB_Name], Status, SUBSTRING(sql.text,(req.statement_start_offset/2)+1, CASE WHEN statement_end_offset=-1 OR statement_end_offset=0 THEN (DATALENGTH(sql.Text)-req.statement_start_offset/2)+1 ELSE (req.statement_end_offset-req.statement_start_offset)/2+1 END) [SQL Statement], Command, Wait_Type, req.Start_Time, Session_ID, Wait_Time, Wait_Resource FROM sys.dm_exec_requests req OUTER APPLY sys.dm_exec_sql_text(sql_handle) sql WHERE Session_ID > 50 -- Ignore system queries -- AND DB_NAME(database_id)='DatabaseName' -- ADD FILTER IF DESIRED ORDER BY req.Start_Time
  • Click Execute of F5 (multiple times as needed).

  • To investigate a line from the report above (see screenshot example below): right-click the desired SQL Statement on the SSMS Results Grid report → Copy → Paste into a Notepad



Keywords: Query, Queries, Performance, MS SQL Server, Doing Now, Frozen, SQK Locked query statement