Need Help

• subbkarth

  SSC-Addicted

  Points: 448

  More actions

  July 7, 2011 at 1:47 am

  #389919

  Hi,

  In one of my maintenance plan for a production server faced this issue

  Here is the issue

  Executing the query "ALTER INDEX [PK__antibody__C0E26769245D67DE] ON [d..." failed with the following error: "Transaction (Process ID 85) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Any suggestions ?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  July 7, 2011 at 2:41 am

  #1349477

  You ran into a deadlock.

  You could:

  1) Make sure this maintenance task runs when there is no other activity on the server

  2) Increase deadlock priority

  3) Trace the deadlock and find+fix the offending process

  Hope this helps

  Gianluca

  -- Gianluca Sartori