Symptoms

Slow performance of OOB reports in K2 workspace - all reports took a few minutes to open.
 

Diagnoses

One of the possible cases here is that statistics for relevant tables in K2 database is outdated. OOB K2 database schemas not include any statistics but it can be added by your DBA or just through SQL server policies/settings. In that cases you have to keep this statistics updated. For this specific issue you may want to check and update statistics on the following tables:


/ServerLog].]ProcInst]
/ServerLog].]ProcSet]
/ServerLog].]Proc]

Note on indexes for K2 database: K2 database is shipped with set of indexes out of the box which is targeted to wide variety of scenarios. It is not supported to add any additional indexes except those which are shipped OOB and created by default. Under no circumstances whatsoever can a UNIQUE index be created for K2 DB.

General note about K2 database modifications: No changes to the K2 Database(s) definitions or content are supported unless specifically instructed by K2 support.
 

Resolution

This issue can be resolved by updating statistics on ServerLog tables (in case you have statistics enabled for these tables and it was outdated).