SQL Waits

Types of Waits

Check sys.dm_os_wait_stats (Transact-SQL) to see the full list (SQL Server 2017)

Wait statistics can be checked using sys.dm_os_wait_stats DMV.

SELECT * FROM sys.dm_os_wait_stats

These statistics are not persisted across SQL Server restarts, and all data is cumulative since the last time the statistics were reset or the server was started.

--Reset to zero Wait statistics
DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);  
GO