Optimized locking is a new Azure SQL database engine feature recently announced that drastically reduces lock memory and the number of locks concurrently required for writes. Optimized locking helps on reducing lock memory as very few locks are held for large transactions. In addition, optimized locking also avoids lock escalations and this allows more concurrent access to the same…
Continue Reading demiliani’s Article on their blog
Dynamics 365 Business Central, Azure SQL and Optimized Locking
Optimized locking is a new Azure SQL database engine feature recently announced that drastically reduces lock memory and the number of locks concurrently required for writes. Optimized locking helps on reducing lock memory as very few locks are held for large transactions. In addition, optimized locking also avoids lock escalations and this allows more concurrent…
Blog Syndicated with demiliani’s Permission
More About This Author
Array
- Business Central24 April 2024Dynamics 365 Business Central: Edit in Excel and Long Running SQL queries
- Business Central15 April 2024Dynamics 365 Business Central 2024 Wave 2 release plans: “as is” and “to be”
- Business Central10 April 2024Dynamics 365 Business Central and Shopify connection: access key rotation.
- Business Central10 April 2024Azure Functions: .NET 7 support is ending and you should upgrade to .NET 8.