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!

Construction worker

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

Hen's teeth'

It has only occurred 1 time in 8 weeks

Breakdown of the 5 rarest wait types