Clarity : Slow Performance with MSSQL 2014 with compatibility mode 120

Products

• Clarity PPM On Premise

Issue/Introduction

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?
 

Environment

Release: 15.5
Component:

Resolution

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