Notifications
Announcements
No record found.
we upgraded to GP2018, and also upgraded from SQL2014 to SQL2017 (version 14.0.3335.7)
the DYNAMICS and COMPANY DB compatibility level are now set as SQL Server 2014 (120)
should I just keep it as it is or change to
SQL Server 2016 (130)
SQL Server 2017 (140)
thanks.
I always set the compatibility level to the version of SQL running. However, I have never seen this addressed so it will be interesting to see what ansewrs come back on this.
We recommend setting the compatibility level of the database to be that of the SQL version unless there is a reason to do differently, which isn't that common.
I did hear it mentioned that with SQL 2014 there was a performance issue where changing to SQL 2012 helped resolve it, but other than that, nothing from the Dynamics GP side.
Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 456 Super User 2025 Season 2
Martin Dráb 429 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
