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. I use SQL server 2014. your help is highly appreciated.