Symptoms
I have been asked to follow up ticket 78795 by management. We are very happy with the recommendations that were made regarding hardware requirements. Thank you for providing us with server sizing guidelines as they apply to our specific situation. What we are seeking in addition to this is any advice regarding K2 that would help us improve performance.
Diagnoses
Improvements to system performance.
Resolution
There is a stored procedure called Utility.Maintain_IndexDefrag. You should be able to run this manually.
There is a process in place as of smartforms 1.0.7 to reduce the auditlog table. http://help.k2.com/onlinehelp/K2smartforms/DevRef/1.0.7/default.htm_Audit Log Archive.html?TocPath=Database Reference|_____1