I am attempting to investigate if a high SOS_SCHEDULER_YIELD wait type is or is not being affected by Spinlocks. I ran one of Paul Randall's queries to see if what was the difference but I cannot find a reference to the "name" entries from
select * from sys.dm_os_spinlock_stats where collision > 0 order by name;
I have been looking through google/bing/etc and also checked the BOL. Google/MS seems to point me to a white paper (which I read) about investigating possible spinlock issues but never gives a reference for the spinlock DMV in it. Does anyone have a reference for this DMV?
Thanks!