Our SQL Server is experiencing sudden high CPU usage since 12:30am today. This server is used internally so nobody should be accessing the server at that time.
I'm not sure why 12 hours later the CPU usage is still at 100%. Looking at the resource monitor on the server it is
sqlservr.exe that is using 99% of the CPU.
We have re-index jobs that kick off at 12:30am every other morning, but those jobs were completed. These jobs also update the statistics via
I've been researching for the past 3 hours, but most of the answers have been on tuning queries or troubleshooting a single query that is hogging the CPU. ALL of our queries have been slow today, which is very abnormal.. I've checked multiple times for a single query, but haven't found anything.
I've run an
sp_who2 'Active', but there are no processes in the suspended state.
I have tried several different DMV and other queries to pinpoint the issue, but haven't been able to find anything..
It seems like SQL Server is hung up and needs a restart, but I'd like to avoid that at all costs...