SQL Wait Statistics
SQL Server Wait statistics can be used to troubleshooting performance problem. Wait statistics are broken down into three type of waits:
Resource waits: work thread is waiting for access to server resources. Such as lock, latch and disk I/O waits. Queue waits: work thread is idle and waiting for work to be assigned. Such as deadlock monitoring and deleted record cleanup. External Waits: SQL Server is waiting for external process to complete, like linked server query.
Posted by John Liu Monday, November 22, 2021