Project Properties page is slow to load - Modern UX

Products

• Clarity PPM On Premise

Issue/Introduction

The Project Properties page, in the Modern UX, loads very slowly.

• It only happens sometimes
• It is observed randomly by different users
• Most of the users reporting it are power users of the application
• It is observed most often at peak hours
• Database used is MS SQL Server

Scenario:

• An attribute is defined in the Project object of data type 'Aggregated'
• It uses data from Status Report sub-object to calculate a value
• An 'API Attribute ID' is assigned against this attribute, to make it available for use in the Modern UX

Cause

• SQL Server assigns a bad execution plan at certain times to the SQL code that fetches data for this custom attribute.

Resolution

1. Remove 'API Attribute ID' from this custom attribute, if it is no longer required
2. Work with DBAs to determine why the DB changes execution plans randomly.