Learn Dynamics 365 Finance and Operations(Axapta)

Introduction In this article you can find information about what Lock, Deadlock, Transaction, Optimistic concurrency mode, and Pessimistic concurrency mode are. Let’s begin. As you may know the insert, update, and delete table operations are executed in scope of a transaction. Several records can be inserted, updated, or deleted in scope of one transaction. Transaction mechanism allows rolling back all changes if transaction is aborted. In Dynamics AX a developer decides when a transaction is started and when a transaction is committed with the help of the  ttsbegin  and  ttscommit  keywords. Lock To understand the deadlock, it is required to understand the lock. Let’s recall what lock is and when it occurs. When a record is inserted, updated, or deleted, this record is locked until the transaction is committed. What does lock mean? When a record is locked, it means that the record is in a “draft” state. That is because at that moment it is unclear if the changes wi

This Article provides information about how to configure database and windows server for Microsoft Dynamics AX. To achieve optimal Microsoft Dynamics AX performance, we must correctly configure the database infrastructure.  You must have knowledge in following areas: ·           Windows Server administration. ·           SQL Server administration. Specific areas of knowledge include advanced configuration options, memory management, performance management, and troubleshooting. ·           Microsoft Dynamics AX system administration. Recommendation on Tune DB operations: # Recommendation Reference 1 Enabling trace flags 4136 ,1117 and 4199 on SQL server. T-4136 : Disable parameter sniffing T-4199 : Activate query optimizer fixes T-1117 : DB files growth 2 Disabling index hints from AX configuration and thereby allowing SQL to decide the best way to process the query. Best Practice 3 Making sure that entire table cache is not enabled