Until today, i'd never really had to dig into the guts of SQL Server (2005). Oracle; no problem but that was a few years back as well.
Anyway, we've got an application which uses alot of stored procedures to manage the data; DOA layer interacts with stored procedures which in turn create the d/b rows. Anyway, within the app, we use tables to hold sequences as, unlike Oracle, there is no sequence type object. This means that every time we want the next value in a sequence, we get the value in a table, add 1, delete the existing value and insert the new one.
Anyway, as we'd scaled up our application with a customer we'd noticed dealock errors in the application logs. This told us which stored processes were failing but not really why.
Anyway, long story short, the links to Bart Duncans blog were invaluable for sussing out was was happening.
Deadlocks Part 1
Deadlocks Part 2
Deadlocks Part 3
No comments:
Post a Comment