Detect current running exec command - SQL Server

Question

I have a bunch of exec commands running stored procedures, 25 of them to be precise.

exec stp_1
exec stp_2
exec stp_3

and so on...

Is there a way to know which exec command is executing? In the query window,I only see "executing query".I ran sp_who but can't tell which exec is executing.

Dhaval · Accepted Answer · 2017-05-16 16:37:11Z

1

Try This

             SELECT      r.start_time [Start Time],session_ID [SPID],
            DB_NAME(database_id) [Database],
            SUBSTRING(t.text,(r.statement_start_offset/2)+1,
            CASE WHEN statement_end_offset=-1 OR statement_end_offset=0 
            THEN (DATALENGTH(t.Text)-r.statement_start_offset/2)+1 
            ELSE (r.statement_end_offset-r.statement_start_offset)/2+1
            END) [Executing SQL], 
            Status,command,wait_type,wait_time,wait_resource, 
            last_wait_type
FROM        sys.dm_exec_requests r
OUTER APPLY sys.dm_exec_sql_text(sql_handle) t
WHERE       session_id != @@SPID 
AND         session_id > 50 -- don't show system queries
ORDER BY    r.start_time

answered May 16, 2017 at 16:37

Dhaval

2,3791 gold badge15 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ranjana Ghimire · Accepted Answer · 2017-05-17 05:50:04Z

0

Try this:

SELECT
DMExQryStats.last_execution_time AS [Executed At],
DMExSQLTxt.text AS [Query]
FROM
sys.dm_exec_query_stats AS DMExQryStats
CROSS APPLY
sys.dm_exec_sql_text(DMExQryStats.sql_handle) AS DMExSQLTxt
ORDER BY
DMExQryStats.last_execution_time DESC

edited May 17, 2017 at 5:50

Ranjana Ghimire

1,8451 gold badge14 silver badges22 bronze badges

answered May 16, 2017 at 21:13

Luciana Rodrigues

291 silver badge7 bronze badges

Collectives™ on Stack Overflow

Detect current running exec command - SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related