SQL Server - sys.dm_os_spinlock_stats

select
   name,
   collisions,
   spins,
   spins_per_collision,
   sleep_time,
   backoffs
from
   sys.dm_os_spinlock_stats
order by
   spins desc;