Clarity PPM: Performance with MSSQL 2014 with compatibility mode 120

Document ID : KB000111084
Last Modified Date : 14/08/2018
Show Technical Document Details
Question:
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?
 
Answer:
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