SQL Server instance is taking 100% cpu. I tried to find the active sessions using sp_who2 'active' and I got one select statement in running. but when I see the cpuTime column for that, the value is 1063
I believe that query is taking very little CPU.
But why the SQL Server is taking 100% CPU? how to find what else is taking cpu?