I have an interesting problem that I don't know the answer to! That's why i'm posting
Anyway, we have an SP on our SQL Server that is typically called around 4 times per second. The CPU Usage per execution is around 50,000. However, we had a particularly busy time and the SP was getting called around 8 times per sec, but the CPU per execution went up to 600,000!
At the same time, another SP on the same DB and Server which normally get called 20 times per sec and uses 6000 CPUs per execution went up to around 450 times per second but the CPU per execution only rose to around 6500...
Any idea what may have caused the first SPs CPU usage to go through the roof?
Is there more info I need to provide for a better diagnosis?
If the 2 Sprocs hit a common table would that cause the CPU rise?
Any help would be appreciated. And do let me know if you need more info.