Waitopedia is a comprehensive resource of information about SQL Server waits.
It combines data analysis with descriptions and insights that are edited by the community. The analysis is based on 2.1 TB of data collected from 4207 instances uploaded by 323 Spotlight users over an 8 week period.
The wait type SOS_SCHEDULER_YIELD is as common as muck!
It's 5% of all waits
Breakdown of the 5 most common wait types
The wait type FS_HEADER_RWLOCK is as rare as hen's teeth
