web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :

Batch process locks and performance fix in PU30 in Microsoft Dynamics 365 Finance and Operations

Rahul Mohta Profile Picture Rahul Mohta 21,032

Having locking issues in batch processing

There is a Batch performance fix in PU30 in Microsoft Dynamics 365 Finance and Operations

KB 4530996
Optimize usage of temporary tables in batch processing
Problem description
When using Batch contention prevention feature, temporary tables are not reused efficiently during batch processing. This can increase contention of database schema locks and impact performance of other processes relying on temporary tables.
Fix description
Dispose temporary tables as soon as possible after use so they can be reused in further processing. This reduces the total number of temporary tables created and reduces schema lock contention. Fixed in PU30.
pastedimage1574835929381v1.png

Comments

*This post is locked for comments