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 1.9 TB of data collected from 8727 instances uploaded by 1101 Spotlight users over the last 15 weeks. This pool of data continues to grow each day.

The wait type PREEMPTIVE_XE_GETTARGETSTATE is as common as muck!

Construction worker

It's 16% of all wait times in a typical hour

Breakdown of the 5 most common wait types

The wait type MSQL_XACT_MUTEX is as rare as hen's teeth

Hen's teeth'

It has only occurred 1 time in the last 15 weeks

Breakdown of the 5 rarest wait types