IO_COMPLETION, SLEEP_TASK, EXECSYNC, RESOURCE_SEMAPHORE_QUERY_COMPILE, MEMORY ALLOCATION, CMEMTHREAD, ASYNC_NETWORK_IO…?
Let’s dive into some of the weirder waits you might see coming from SQL Server, how they can be part of performance problems, and how to solve them.
If you have questions about any of these wacky waits or SQL Server hardware limits, look no further.
20 Minutes, Streamed