I have run Paul Randals wait script and can see
SOS_SCHEDULER_YIELD is at
60% with an average signal wait of
10ms. I have also run a script to find out the what percentage of my waits are signal waits and in total it is 47%.
I can seen in task manager that the CPU usage is high and I believe I do have a CPU issue, but how do I find which queries are the ones causing the signal waits?
Just to update: The version of SQL is 2008R2