HomeWinBuzzer NewsMicrosoft Dynamics 365 Can Now Run with SQL Server 2016, Leading to...

Microsoft Dynamics 365 Can Now Run with SQL Server 2016, Leading to Performance and Efficiency Improvements

The tandem lets users run Dynamics 365 on-premises with SQL Server 2016, and increases efficiency by disabling lock escalation depending on the number of locks present.. Microsoft is also evaluating the use of native compilation of tables and stored procedures and In-memory Columnstore.


has rolled out an update for SQL Server 2016 CU2 that lets users run on-premises via database compatibility level 110. According to a Microsoft spokesperson, admins will “see improved performance by setting the organization database with trace flag 1224″.

The setting reduces CPU usage by disabling lock escalation as the number of locks varies. This pairs with SQL Server 2016's high availability enhancements, which replace old Database Mirroring technology with a more efficient alternative.

The latest update is one of many performance improvements to SQL Server 2016. In July, it broke the world performance record in an “unparralled” benchmark. The record makes the fastest in-memory database on the planet.

Native Compilation of Tables and Stored Procedures

Despite this, Microsoft continues to look for new ways to improve efficiency. In a blog post, the company states:

“The Dynamics 365 engineering team continues to evaluate these capabilities to enhance the application's performance in upcoming releases.”

One such evaluation is on the native compilation of tables and stored procedures. Success will lead to quicker data access and more efficient execution of queries, resulting in further performance increases.

The team is also highlighting In-memory Columnstore, which “uses column compression to reduce the storage footprint and improve query performance for data warehousing scenarios.”

It's great to see continued improvements in the performance field and no doubt Microsoft will continue to innovate in this area. You can find more information on the latest changes and how to implement them on the Dynamics 365 blog.

Ryan Maskell
Ryan Maskellhttps://ryanmaskell.co.uk
Ryan has had a passion for gaming and technology since early childhood. Fusing the skills from his Creative Writing and Publishing degree with profound technical knowledge, he enjoys covering news about Microsoft. As an avid writer, he is also working on his debut novel.

Recent News