The Cause of Every Deadlock in SQL Server
Deadlocks are the result of application code combined with a database schema that results in an access pattern that leads to a cyclical dependency.
Deadlocks
How To: Troubleshoot Deadlocks In Windows Azure SQL Database (WASD)
On my way back from SQLBits this past Sunday I spent some time drafting a handful of blog posts. One of the posts was on troubleshooting deadlocks in Windows Azure SQL Database (WASD). Imagine my surprise when I went through my RSS feeds today and found this blog post from Chris Skorlinski, written just last … Read more
What Causes Deadlocks?
Application code, that’s what causes deadlocks. Well, perhaps a combination of application code on top of database design, and access patterns, and transaction isolation levels, and… OK, here’s the point I need to make clear: the database engine does not suddenly seize up and start deadlocking transactions arbitrarily because it is tired one day. No, certain … Read more
D(r)eadlocks
Quick quiz: what causes deadlocks? No, no, no. Keep your answers simple. Here, choose from these two options: 1. MS SQL Server, or 2. Applications designed to run on MS SQL Server There, that should make things easy. Can we all agree that MS SQL Server … Read more
