SELECT p.name as SPName, qs.last_elapsed_time/1000 as [LastExecTime(ms)], (total_elapsed_time/execution_count)/1000 as [AvgExecTime(ms)], min_elapsed_time/1000 as [MinExecTime(ms)], max_elapsed_time/1000 as [MaxExecTime(ms)], (total_worker_time/execution_count)/1000 as [AvgCPUTime(ms)], qs.execution_count as ExecCount, qs.cached_time as LastCachedTime, qs.last_execution_time as LastExecTime, (total_logical_reads+total_logical_writes)/execution_count as AvgLogicalIOs, min_logical_reads as MinlogicalReads, max_logical_reads as MaxlogicalReads, min_logical_writes as MaxlogicalWrites, max_logical_writes as MaxlogicalWrites from sys.dm_exec_procedure_stats qs, sys.procedures p where p.object_id=qs.object_id order by [LastExecTime(ms)] desc