Dear all,
I have experienced a downgraded performance in SQL server. after tracing the issue I found a deadlock in inventtrans table happens when two accountants post a retail statement of two different branches of our retails.
the trace of the error is in the attached graph.


*This post is locked for comments
I have the same question (0)