web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) deadlock in inventtran...

Microsoft Dynamics AX (Archived)

deadlock in inventtrans table when two users post retails statement

(0) Share

Report

Report

Posted on by Community Member

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.

63108.Error.png

3660.error1.png

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

Did you enable the trace flags suggested to be used with SQL Server in combination with the Dynamics AX DBs? There is one for improving lock escalation handling.

[View:https://blogs.msdn.microsoft.com/axinthefield/dynamics-ax-and-sql-server-trace-flags-quick-and-dirty/:750:50]

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 16

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans