How long a SP executed

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

SQLAJ Ten Centuries Points: 1359 More actions · Answer 1

Query the Plan Cache using sys.dm_exec_query_stats. There is a column called "last_execution_time".

______________________________
AJ Mendo | @SQLAJ

surilds Right there with Babe Points: 718 More actions · Answer 2

It gives the last execution time. But how to find out the start & end time?

Richard Fryar Hall of Fame Points: 3457 More actions · Answer 3

To look for it within a 1 hour window, 2 hours ago - and assuming you know the procedure name:

select qs.last_execution_time, qs.last_elapsed_time, st.text

from sys.dm_exec_query_stats qs

cross apply sys.dm_exec_sql_text(qs.sql_handle) st

where last_execution_time between dateadd(minute, -150, getdate()) and dateadd(minute, -90, getdate())

and st.text like '%YourProcNameHere%'

surilds Right there with Babe Points: 718 More actions · Answer 4

Is "last_elapsed_time" = total execution time of the SP?

Richard Fryar Hall of Fame Points: 3457 More actions · Answer 5

Yes. It is the total amount of time it took to execute, in microseconds.