After upgrade to MSSQL 2014 SP2, we notice a slowness within CA Clarity 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
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