SQL Server 2016 already comes with rich capabilities to help meet business demands. A cumulative update released on January 30. makes it even more efficient—as you can now run Dynamics 365 on premises with SQL Server 2016 CU2, using database compatibility level 110.
Users will see improved performance by setting the organization database with trace flag 1224 setting, that “reduces CPU usage by disabling lock escalation based on the number of locks.”
In addition, high availability enhancements mean the obsolete Database Mirroring technology has been replaced with a more efficient Always On Basic Availability Groups, says Paul Liew.
“SQL Server 2016 comes with a set of rich capabilities that can help you solve and meet your business needs. 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,” Liew explained.
Another capability In-memory Columnstore, “uses column compression to reduce the storage footprint and improve query performance for data warehousing scenarios.”
For more on What’s New in SQL 2016 (Database Engine), and help to maintain and fine-tune applications, visit this documentation.
Also, back in fall of 2016, Microsoft introduced a new powerful Dynamics 365 feature called “business recommendations”, that enables a Business Analyst or System Customizer to guide users to optimal data based on intelligence they have about their business.
Recommendation action in the Components tab
“‘Business recommendations’ work like Show Error action by adding an indicator next to a form field. When the indicator is clicked, a bubble with a recommendation pops-up that tells how to fill out the field based on other data on the form,” explained the Dynamics team. “You can associate a Portable Business Logic (PBL) action with the business recommendation, that can automate setting the value to that or other fields, making the experience much more streamlined for the user.”