The SQL Server Wait Types with their descriptions
Wait Statistics in SQL Server indicate sql server performance in relation to different resources like CPU, Disk usage, Memory etc..
SQL Server Activity monitor waiting tasks is another important place to observe what SQL Server is waiting on. Activity monitor has different sections like Processes, Resource Waits, Recent Expensive Queries and Data IO Stats.
|“Wait_Type, Area, Usage, Version”||Description||Action|
|Used to indicate a worker is waiting on a asynchronous I/O operation to complete not associated with database pages||Since this is used for various reason you need to find out what query or task is associated with the wait. Two examples|