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