Skip to main content
Nintex Community Menu Bar

K2 Database Maintenance Best Practices

  • April 9, 2009
  • 1 reply
  • 35 views

Forum|alt.badge.img+9
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?

1 reply

Forum|alt.badge.img+9
  • Nintex Partner
  • April 15, 2009

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.