Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Unanswered: Deadlock problem with UPDATE

    I have n processes which update rows in a table using the primary key (I am sure every process updates different rows). The table is defined with "lock datarows scheme", an therefore I would expect no deadlocks. However, I am getting deadlocks. Any ideas ?

  2. #2
    Join Date
    Jun 2003
    Posts
    140

    Re: Deadlock problem with UPDATE

    Hi

    If table is defined with data rows locking scheme, it doesnt mean that dead lock will never occure, you need to detect the exact cause of deadlocking, try following for this

    (1) identify any long running transactions and divide it in shorter one
    (2) enable "print dead lock information" parameter from sp_configure and check where dead lock occures
    (3) check if any other process running at same time uses the same table then tune that sql
    (4)use sp_object_stats to verify dead lock information

    hope this helps
    Last edited by perl; 03-09-04 at 07:16.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •