Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [master]
- SELECT TOP 50
- DB_NAME(ps.database_id) AS database_name,
- OBJECT_NAME(ps.object_id, ps.database_id) AS procedure_name,
- ps.cached_time,
- ps.execution_count,
- ps.execution_count / DATEDIFF(MINUTE, ps.cached_time, GETDATE()) AS calls_per_minute,
- ps.total_worker_time / 1000 AS total_worker_time_ms,
- ps.total_worker_time / ps.execution_count / 1000 AS avg_worker_time_ms,
- ps.min_worker_time / 1000 AS min_worker_time_ms,
- ps.max_worker_time / 1000 AS max_worker_time_ms,
- ps.last_worker_time / 1000 AS last_worker_time_ms,
- ps.total_elapsed_time / 1000 AS total_elapsed_time_ms,
- ps.total_elapsed_time / ps.execution_count / 1000 AS avg_elapsed_time_ms,
- ps.min_elapsed_time / 1000 AS min_elapsed_time_ms,
- ps.max_elapsed_time / 1000 AS max_elapsed_time_ms,
- ps.last_elapsed_time / 1000 AS last_elapsed_time_ms,
- ps.total_logical_reads,
- ps.total_logical_reads / ps.execution_count AS avg_logical_reads,
- ps.min_logical_reads,
- ps.max_logical_reads,
- ps.last_logical_reads,
- ps.total_physical_reads,
- ps.total_physical_reads / ps.execution_count AS avg_physical_reads,
- ps.min_physical_reads,
- ps.max_physical_reads,
- ps.last_physical_reads,
- ps.total_logical_writes,
- ps.total_logical_writes / ps.execution_count AS avg_logical_writes,
- ps.min_logical_writes,
- ps.max_logical_writes,
- ps.last_logical_writes
- FROM sys.dm_exec_procedure_stats AS ps
- --WHERE OBJECT_NAME(ps.object_id, ps.database_id) LIKE 'XXXXXXXXXXXXXXX%'
- ORDER BY calls_per_minute DESC
- OPTION (RECOMPILE)
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement