June 15, 2014 at 12:33 am
Hi All,
I need big favor, Here is my question, I am getting dead lock error.
When I try to insert data from Application, the table I am inserting data has trigger, I think
thats why I am getting dead lock error. The SP I am using through Application to insert data, its very simple
only two statment, first Insert statement and then Update statement, I am using 5 second delay on both statement
but still having problem. Any advise?
Thank You,
June 15, 2014 at 1:10 am
Could you share some more information such as execution plan, sp_lock and sp_who2 output?
Also check out these two articles
😎
June 15, 2014 at 2:48 am
Disable the trigger and try again.
What does the trigger do (update other tables, etc.)?
Do you run a transaction?
June 15, 2014 at 4:09 am
SQL Server 2008 has a system_health extended event session. I'm pretty sure it's capturing information from your deadlock called a deadlock graph. You'll need to query the files to get the information. Here's an article on how to get that done[/url]. You won't have to turn on traceflags or recreate the issue. When you have the deadlock graph, zip it up and post it here to get help interpreting it.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
June 15, 2014 at 2:46 pm
And for some general info - https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply