ZARZA We are Zarza, the prestigious firm behind major projects in information technology.
Listen "Which Queries are Causing my Wait Stats?"
Episode Synopsis
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.
More episodes of the podcast Dear SQL DBA
Jer and Kendar Explore Optimized Locking
04/09/2023
Erik Darling on Performance Tuning
21/08/2023
Data Roles: DBA, DBRE, and Data Engineer
04/08/2023
In God we trust