Home Forums Article Discussions Article Discussions by Author Discuss content posted by Praveen Voleti A Deadlock Occurence and Resolution RE: A Deadlock Occurence and Resolution

  • February 3, 2009 at 4:15 pm

    #937636

    amiller (2/3/2009)

    🙂 Very interesting and with many information I didn't know. One more, does the ALLOW_PAGE_LOCKS option on indexes in the tables involved matters for deadlocks?

    thanks

    Albert

    Albert,

    YES. These options make a difference. See the following thread where having ALLOW_PAGE_LOCKS and ALLOW_ROW_LOCKS OFF caused deadlocking to occur.

    http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/c5356da9-167e-4143-a64b-9a39dbc176b6/

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]