We have an 8 core 32Gb windows 2008 ent x64 machine running SQL 2005
Enterprise SP3 CU5. This server supports a Dynamics 2009 AX environment with
a few hundred users on currently.
Occasionally we have a situation where all the cores max to 100%, a lot
(10+) of our processes go into Runnable but there's no apparent locking and
it's extremely hard to find what exactly is causing the issue.
Is there a 'silver bullet' to find exactly what SPID is causing the issues
when you hit a problem like that or is it a comparison of a number of
Occasionally i've tracked it down to be a Dynamics user which has locked 2
of the cpus (MAXDOP = 2) and that manifests in that their user is
Ending-Blocked in the Dynamics client. The most recent occasion though there
were no clues at all, no suspended/blocking threads and even taking the
drastic step of killing all the 'Runnable' processes only provided a
There is nothing else running on the SQL server save AV etc.
Any help appreciated!