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?
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