Resource Waits: Lock Waits: waiting for a shared lock on a table - 'LCK_M_S' IO Waits: waiting for a page to be read from disk.
'PAGEIOLATCH_SH' Memory Waits: waiting for a semaphore to be released to access memory
'RESOURCE_SEMAPHORE' Queue Waits: CPU Waits: waiting for another process to complete.
its work - 'CXPACKET' Memory Waits: waiting for an external memory allocation to be released.
'MEMORY_ALLOCATION_EXT' Wait for Tasks: Backup and Restore Waits: waiting for a backup or restore operation to complete - 'BACKUPIO', 'RESTOREIO'
External Waits: Waiting for a CLR or extended stored procedure - 'CLR_AUTO_EVENT', 'EXTENSIBLE_HASH_LOAD' Synchronization Waits: Waiting for a semaphore or a latch - 'LATCH_EX', 'ASYNC_IO_COMPLETION' User Waits: Waiting for user input or action - 'WAITFOR', 'SLEEP' Network Waits: Waiting for network resources or connectivity - 'ASYNC_NETWORK_IO', 'NET_WAITFOR_PACKET
March 8, 2023 18K 8
