SQL Server Performance Forum – Threads Archive

DEADLOCK problem

I’m having a problem with deadlocks given timeout to the sales people when they try to insert into the database. this is what I got from the log file 11/03/2005 09:22:39 P=1976 T=2756 22671818:22671777.49 msec formprocessor.dll SendFormResult(): Could not insert response form into the database. Rolling back transaction.
Message: Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Type: System.Data.SqlClient.SqlException
SQL Errors:
State: 50
Number: 1205
Server:
LineNumber: 28
Procedure: usp_InsertResponseHeader
Errors:
Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (Line: 28 Any idea how to fix it?
thanks

Some times that problems is because lack of tuning.
I suggest to see execution plan of that query and find out if any indexes are neccesary.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Check the reference in thishttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11190 post also. HTH Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>