After upgrade to MSSQL 2014 SP2, we notice a slowness within CA PPM on certain pages, such as Project - Tasks. What is causing the issue and how to workaround it?
Release: CODCVU9900-15.1-PPM SAAS-View Only Userpack for-Canadian Government Entities
This issue was reported as DE42894 and is resolved in Clarity 15.6 targeted for March 2019.
To workaround this, choose one of the following workarounds:
Option 1: Remove aggregation on Project - Task screen
Option 2: Set the Compatibility Mode on the database to 110
Option 3: Enable Dbcc-trace on (9481-1); clear the system cache with DBCC FREEPROCCACHE