Which Queries are Causing my Wait Stats?
May 25, 2017•35 min
Listen to this episode in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more
Episode description
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.
For the best experience, listen in Metacast app for iOS or Android