Skip to main content
Does anyone know of any best practices for maintaining the K2 blackpearl databases?  are there recommendations on when to rebuild indexes or other general maintenance tasks?

The general SQL best practices on re-indexing would still apply.


Some of these reference might be useful (from a quick search on Google).


http://www.phwinfo.com/forum/ms-sqlserver-server/318120-best-practices-table-reindexing-sql-2008-vldbs.html


http://vyaskn.tripod.com/sql_server_administration_best_practices.htm


Other than that, you should monitor the growth size of the K2ServerLog database to see if Process Archival is needed.


Reply