Microsoft SQL Server 2019 (RTM-GDR) (KB4583458) - 15.0.2080.9 (X64) Nov 6 2020 16:50:01 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)
SQL Server 2019 Server upgraded from 2014. Issues are high parallelism, application locking up and high latency. Database running in 2014 compatibility mode.
We have tried modifying MAXDOP to 4 with CTFP at 75 to see if this resolves the issue. However, this was not successful though it worked well with other servers. We set maxdop back to 8 aligned with tempdb files and CFTP back to 50. all other configs are at MSFT best practices. I am wondering if it could be related to application logic not compatible with 2019 or perhaps upgrading the version of 2019. Any help would be appreciated.
My best to you all.