Category: Deadlocks

Leveraging Context_Info & Extended Events for Deadlock Troubleshooting

Hellooo, yet another article related with deadlock troubleshooting for future reference. Who hasn’t ever needed to capture value of variables passed for a stored procedure that was part of a deadlock and was the victim(or not)…? The main objective of this article is to present an idea on how to output variables to extended events when

Continue reading

Beware of SQL Server Online Index Rebuilds with an unexpected Update Stats causing locking and deadlock storms on complex distributed environments

Hello, Hope everything is running great! It is not that uncommon, that large/complex database environments might have an overlapp of maintenance commands being executed, being one of the classics the one bellow: Tipically DBA’s design their maintenance processes (that might include Integrity Checks/ Index Rebuilds/Reorgs/ Update Stats) to run on a daily basis under a

Continue reading