NAV 2009/2013/2015/2016 on SQL2014 - Use Delayed Durability = FORCE or ALLOWED during data upgrade?

rsaritzky
rsaritzky Member Posts: 469
in SQL Performance
Someone in another thread mentioned using Delayed Durability = FORCE or ALLOWED during data upgrades if the SQL Server is SQL2014. The article he referenced is:

http://sqlperformance.com/2014/04/io-subsystem/delayed-durability-in-sql-server-2014



If you do a demo install of NAV2016, Delayed Durability is set to "Disabled".

Has anyone experimented with this during database upgrades, particularly from NAV2009->NAV21xx? Aaron Bertrand's results (author of article mentioned) seem to indicate a substantial increase in SQL performance if this feature is turned on. I'm wondering if anyone in the NAV community has tried it yet.

Ron
Ron

Categories