SQL using lot of CPU, but not much showing up in sp_who
Posted on 2013-01-01
Version is SQL 2000 Standard Edition (SP3).
Client says main application is running slow. Suspicion is that another database is using too much SQL and the main application is suffering.
In task manager SQL is using most of CPU.sp_who2 shows almost no activity.
I'm running a 24/48 hour performance monitor counters to see what is happening. I included transaction/sec on each of two main databases.
Where to look next? Is there something else that can tell me which database is taking all the CPU?