Deadlock Troubleshooting, Part 2

Bart Duncan continues his series on deadlock troubleshooting, with scripts that allow you to reproduce a deadlock, along with instuctions on how to use trace flag 1222 and the Database Tuning Advisor to troubleshoot and resolve the deadlock situation. This is a great example on how to properly resolve a deadlock with proper indexing, as opposed to just using NOLOCK hints.
This entry was posted in SQL Server 2005. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s