Every action within Clarity will take about 1-2 minutes to load. For example, not even able to create a project during this time.
The issue is intermittent and happens during the morning hours, but is resolved when users are logged off.
There are hundreds of queries running in the SQL Server database.
Release : 15.9.1, 16.0.1
The queries captured by the DBA team previously and confirming with
SQL Server Management Studio > Reports > Top IO and CPU time reports and both confirm the query is coming from
function: NK_SUM_JULIAN_FCT
The long-running query produced by the action, pertains to the 'Remaining Allocation' field on the Modern Project > Staff page.
The issue is resolved with database maintenance.
Reach out to the DBA team to request update on stale statistics to improve the performance.