Post reply

Update statement Deadlock

  • July 21, 2011 at 1:17 pm

    #254142

    Update Ph set field1='1bc' where id =1

    Update PH set field2='add' where id =3

    Why do these update statement cause the deadlock?

    It causes pagelock. id is not index in table.

    Thank you.

  • July 23, 2011 at 3:48 am

    #1357404

    Turn on trace flags for deadlock and check the deadlock grph or run both the statements and turn on profier for deadlock events in background.

    This will enable you to analyse the reason behind it.

    Manu

  • July 23, 2011 at 6:20 am

    #1357413

    You sure its causing deadlock??

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply