SQL High CPU scenario troubleshooting using sys.dm_exec_query_stats and RING_BUFFER_SCHEDULER_MONITOR ring buffer in sys.dm_os_ring_buffers
I ran into a scenario a while ago that I thought I would share, where we were troubleshooting high CPU on SQL Server. The sporadic High CPU ( 90+ % ) pretty much brought the box down to its knees for a period of 5-10 minutes minutes or so, and then cleared itself up.
If you liked this post, buy me a Coffee.
