Symptoms
the following SP which cause of most Dead lock now on production servers is:
K2.Server.kProcInstSave
please advice how to solve this?!
Diagnoses
Issue is resolved after unchecking the Dynamic checkbox for all the 3000 roles and changing the Interval in [K2].[Server].[DestQueue] from 5 to 28800 then restarting the k2 service
Resolution
Issue is resolved after unchecking the Dynamic checkbox for all the 3000 roles and changing the Interval in [K2].[Server].[DestQueue] from 5 to 28800 then restarting the k2 service