Avatar of introlux
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

SQL Server 11.0.3401 - CPU 100% - HELP


We are having odd issues where the CPU usage is increased to 100%, the process is SQL service. I have tried to investigate what could be the cause by using the following commands:

select * from sys.dm_exec_query_stats order by total_worker_time desc
select * from sys.dm_exec_query_stats order by execution_count desc
select * from sys.dm_exec_query_plan(0x0600050021785620D065754C0100000001000000000000000000000000000000000000000000000000000000)

However what I do not know, what is best practice to investigate this. Any help on this matter will be appreciated.


Microsoft SQL ServerWindows Server 2012Microsoft Server OS

Avatar of undefined
Last Comment
Scott Pletcher

8/22/2022 - Mon