I have seen a Microsoft SQL Server with CPU stuck near 100% (RAM was using 20GB of 32GB). Task Manager showed that the SQL Server process was using the most of the CPU.
The strange thing is
exec sp_who2 doesn't return anything RUNNABLE.
Any ideas please?
In the meantime it is being scheduled to restart. It would be nice to know what caused it, and how to solve it without a restart.