Product DescriptionIn this first installment of the hands-on series, SQL Server guru Kalen Delaney walks you through troubleshooting your SQL Server performance problems. In this installment, she dives deep into locking and blocking: what causes them, how to fix them when they are a problem, and how to look into the system tables to troubleshoot problems. The hands-on series has lots of sample code to get you started and debugging your own performance problems quickly! Tech edited by Itzik Ben-Gan.
Customer Reviews
Average Rating:
Rating: - Worth the money if you want to understand locking
This 90 page pamphlet is a great choice if you want to understand how to pinpoint and analyze locking. The author delves into considerable detail on locking, isolation levels, monitoring, deadlocks, and lock escalation.
The author has worked for Microsoft for many years and she knows her stuff. It is apparent she is intimately familiar with inner workings of SQL Architecture unlike many SQL book authors.
Although this pamphlet is great in deciphering and understanding locking, ... Read More
