I was wondering if I could get some help with something.
I am seeing A LOT of SOS_SCHEDULER_YIELD waittimes on my machine. However, I don't see any issues with CPU from perfmon. Additionally, I have 0 runnable_tasks_count for sys.dm_os_schedulers.
What I am trying to really figure out is why a process is yielding on the CPU. I know how the process works from a design standpoint, but is there a way to figure out the actual processes, spids, querys, etc that would actually tell me what was yielding.