Hi!
While ago we designed a process ( document upload to sharepoint, adding some user rights, entering aditional data ...) and it is running on production environment for about a year. But lately we are getting strange errors in K2 manager. All systems become very slow (sharepoint) and we get errors of type "System out of memory" or "Time-out" in K2mng.
After reviewing the system we came to conclusion, that the main problem is in K2Log DB. We ran some counters and find out, that the number of read requests on K2Log DB was abnormally high - 75 millions - every second. That leads to SQL server overload and everything stops for short time. This is very strange behaviour of K2Log database!We thought that K2 archive utility would help, but the number of requests remains the same (K2Log was 16Gb large, now it's 3Gb)..
Had anyone of you encountered the same problem and find solution to that? This is really important, so please if you got any suggestions please write them down, cause i run out of ideas!
regards;
Klemen