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?
Release: 15.5
Component:
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