24 lines
586 B
SQL
24 lines
586 B
SQL
use arizona
|
|
|
|
SELECT p.name, max(ps.last_execution_time) last_time
|
|
FROM sys.dm_exec_procedure_stats ps
|
|
JOIN sys.procedures AS p ON (ps.object_id = p.object_id)
|
|
GROUP BY p.name
|
|
|
|
|
|
SELECT
|
|
DB_NAME(database_id) AS database_name,
|
|
OBJECT_NAME(object_id, database_id) AS object_name,
|
|
cached_time,
|
|
last_execution_time,
|
|
execution_count,
|
|
total_elapsed_time,
|
|
total_worker_time
|
|
FROM
|
|
sys.dm_exec_procedure_stats
|
|
WHERE
|
|
OBJECT_NAME(object_id, database_id) IS NOT NULL
|
|
and DB_NAME(database_id) = 'arizona'
|
|
ORDER BY
|
|
last_execution_time DESC;
|