Friday, December 23, 2005

How To Resolve A Deadlock

I stumbled upon this SQL Server technical bulletin and it gives one example of how to resolve a deadlock. Typical methods you can use to resolve deadlocks include:
Adding and dropping indexes.
Adding index hints.
Modifying the application to access resources in a similar pattern.
Removing activity from the transaction like triggers. By default, triggers are transactional.
Keeping transactions as short as possible.
I won't go into details here since you can read it all at the following link (SQL Server technical bulletin - How to resolve a deadlock)

Also check out the following deadlock links
Deadlocking
Handling Deadlocks
Minimizing Deadlocks
Troubleshooting Deadlocks
Lock Compatibility

And of course if you really want to know everything about locking I recommend the following book (in PDF format): Hands-On SQL Server 2000 : Troubleshooting Locking and Blocking by Kalen Delaney (Inside SQL Server 2000)

3 comments:

Wally Banners said...

Dude what is sql anyways? I have it on my pc startup adn i am cluess to what it does? merry xmas man killer blog.

kanenas.net said...

Can I install a MS-SQL Server 2000 in a WinXP Professional System ???

Thanks

SQL said...

if it's developer edition then yes, read this http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx