I have identified a deadlock by using Solarwinds, I have noticed that it is happening in a specific table, that table only has a primary key, which tells me that the deadlock makes sense since every time it has to scan the whole table in every transaction since the current index does not cover the query.

My question is, how can I reproduce that ? Is it possible or is something the end user can give me (steps from the app)

Your Answer

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

Browse other questions tagged or ask your own question.