Wednesday 27 March 2013

TOP 5 costly Stored Procedures in a SQL Server Database

Execute this query on corresponding Database

SELECT TOP 5 obj.name, max_logical_reads,
 max_elapsed_time
FROM sys.dm_exec_query_stats a
CROSS APPLY sys.dm_exec_sql_text(sql_handle) hnd
INNER JOIN sys.sysobjects obj on hnd.objectid = obj.id
ORDER BY  max_logical_reads  DESC

No comments:

Post a Comment

Total Pageviews