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/… Jun 28, 2017 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, 2017 at 9:01
  • 1
    Ask someone with sysadmin access to extract the deadlock graph for you. Jun 28, 2017 at 9:12

1 Answer 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.


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:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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