Tag Info

Hot answers tagged

2

You can use this select st.text, qp.query_plan, qs.plan_handle, total_worker_time/execution_count AS [Avg CPU Time] FROM sys.dm_exec_query_stats AS qs cross apply sys.dm_exec_sql_text(qs.plan_handle) st cross apply sys.dm_exec_query_plan(qs.plan_handle) qp if you are using sql server 2008 and above you can configure Extended Events as ...



Only top voted, non community-wiki answers of a minimum length are eligible