Thursday, 3 December 2009

Top 100 Queries from particular instance of server

Top 100 Queries from particular instance of server:
create procedure usp_top100_queries as select top 100 a.total_worker_time,b.text from sys.dm_exec_query_stats a cross apply sys.dm_exec_sql_text(a.plan_handle) as b order by 1 desc

No comments:

Post a Comment