Category : Deadlocks - SentryOne Team Blog

Category: Deadlocks

New Deadlock Visualizations in SQL Sentry and Plan Explorer

New Deadlock Visualizations in SQL Sentry and Plan Explorer

Product Manager Aaron Bertrand gives a brief walk-through of the new deadlock visualization options in Plan Explorer and SQL Sentry.

Resolving Key Lookup Deadlocks with Plan Explorer

Resolving Key Lookup Deadlocks with Plan Explorer

Greg Gonzalez (@SQLsensei) uses Plan Explorer to walk through troubleshooting a very common type of deadlock : updates conflicting with key lookups.

Paul White : The 2008 R2 Bug Fix That Breaks RCSI

Paul White (@SQL_Kiwi) details a regression bug in RCSI caused by a fix for a different bug. If you are running SQL Server 2008 R2, you should read this.