202
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.
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
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.
Share
Report
All responses (
Answers (
