MS SQL Server

SQL Server High CPU Consumers by Querying the DMV

/

select top (50) st.text as Query, qs.total_worker_time, qs.execution_count from sys.dm_exec_query_stats as qs cross apply sys.dm_exec_sql_text(qs.sql_handle) as st order by qs.total_worker_time […]