Deadlocks

This tag is associated with 1 posts

What Causes Deadlocks?

By Thomas LaRock ⋅ April 22, 2009 ⋅ 2 comments

Application code, that’s what causes deadlocks. And what I mean by that is that the database engine does not suddenly seize up and start deadlocking transactions arbitrarily because it is tired one day. No, certain conditions must exist in order for a deadlock to happen, and all of those conditions require someone, somewhere, to be [...]

D(r)eadlocks

By Thomas LaRock ⋅ December 1, 2008 ⋅ Post a comment

 
 
 
 
 
 
 
 
 
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 does not simply produce deadlocks by itself? In other words, when a [...]

—

My Book


0
Unique
Visitors
Powered By Google Analytics