Dear all, after an upgrade from 2018 R1 to 2019 R1 the system is very very slow, we get permanently time out errors or insufficient system memory in resource pool. Installed all hotfixes, File size fragmenting edited to 512, sp_updatestats run, Reindex of all databases was done, Auto Shrink is False, Recovery model unfortunately Full SQL Server 2012 SP3 Enterprise, DB Server 32GB RAM, Xeon Gold 6138CPU Do you have any other idea? Thank you and best regards Vladi
‎Jun 11, 2019 03:05 AM
Hi - one thing worth checking is the Compatibility level (Options tab of each database). I have seen very poor performance as a result of this not being set to the level specified in the system rqts (should be 2012(110) for FNMS 2019 R1).
‎Jun 11, 2019 03:19 AM
‎Jun 11, 2019 03:25 AM