1

In my application there are many threads which uses insert and select statement to store/retrieve data from database.

I am getting deadlock in my production environment, I have observe deadlock from application log file.

enter image description here I am not able to reproduce same situation on my development environment.

Please give me suggestion to:

  • How to resolve this kind of deadlock?

  • How to get more clear understanding to capture deadlock?

Thank you

  • 2
    Can you post the deadlock graph? You can find it in the system health session. Instructions on how to retrieve it are (for instance) here: blog.sqlauthority.com/2017/01/09/… – spaghettidba Jun 28 '17 at 7:53
  • Deadlock is generated on Production environment and i don't have access to PRD environment database. I am trying to reproduce deadlock on my development environment. – R. Ingle Jun 28 '17 at 9:01
  • 1
    Ask someone with sysadmin access to extract the deadlock graph for you. – spaghettidba Jun 28 '17 at 9:12
1

How to resolve this kind of deadlock?

As you have not provided your deadlock graph it will be impossible to give an answer about how to resolve the deadlock. Even with just deadlock graph sometime it is not possible to give a solution. You might have to trace your calls and see the sequence of calls (involved in the deadlock), look at the execution plan, isolation level etc. Based on what you said (insert and select statement) I suggest you read this post which will give you a good start.

SELECT/INSERT Deadlock

How to get more clear understanding to capture deadlock?

As suggested by @spaghettidba in comment section you can look at the article mentioned there.

Few more articles for you:

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.