Stored Procedure execution

 

Select object_name (object_id, database_id) stored procedure name,
D. cached_time Compilation Time,
D. last_execution_time the last execution time is Ms,
D. total_elapsed_time/1000 total time spent in MS,
D. total_elapsed_time/d.exe cution_count * 1000 as average execution time ms,
D. last_elapsed_time the last execution took Ms,
D.exe cution_count execution times
From SYS. dm_exec_procedure_stats as d
Where object_name (object_id, database_id) in (
Select name
From SYS. Objects
Where type = 'P'
And modify_date> '2017-2-24 17:32:50 ')
Order by 6 DESC;

 

 

-- execution of stored procedures
select S. name,
D. total_elapsed_time,
D. total_elapsed_time/d.exe cution_count as [avg_elapsed_time],
d.exe cution_count,
interval,
total_logical_writes,
interval
from sys. procedures S
Inner join sys. dm_exec_procedure_stats D on S. object_id = D. object_id
order by d.exe cution_count DESC;
go