Applies To: Dynamics 365 (on-premises)
You can now run Dynamics 365 (on-premises) with SQL Server 2016 CU2 using database compatibility level 110 (SQL Server 2012 compatibility level). The application’s performance is improved when you set the organization database with trace flag 1224. This setting reduces the CPU usage by disabling lock escalation based on the number of locks. For details, please see Improve performance when you use Microsoft Dynamics 365 with SQL Server 2016.
The performance of SQL Server 2016 is also improved with the High Availability Enhancements. The obsolete Database Mirroring technology has been replaced with a more efficient Always On Basic Availability Groups for high availability.
SQL Server 2016 comes with a set of rich capabilities that can help you solve and meet your business needs. The Dynamics 365 engineering team continues to evaluate these capabilities to enhance the application’s performance in upcoming releases. An example of these capabilities that we are evaluating is the ability to perform Native compilation of Tables and Stored Procedures. This capability allows faster data access and more efficient query execution for better performance. Another capability that you should consider is the In-memory Columnstore. In-memory Columnstore uses column compression to reduce the storage footprint and improve query performance for data warehousing scenarios.
Please see What’s New in SQL 2016 (Database Engine) to help you maintain and fine-tune your applications.
– Paul Liew