Dear SQL DBA cover image

Dear SQL DBA

Which Queries are Causing my Wait Stats?

May 25, 2017
34:45

You've got some troubling wait stats in SQL Server. How can you tell which queries are causing those waits? Kendra discusses the pros and cons of different techniques to track down the cause of both common and tricky waits in SQL Server, including CXPACKET, PAGEIOLATCH, LCK, RESOURCE_SEMAPHORE, and THREADPOOL waits.

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner