Does the K2 application/databases have something in place for maintenance of the indexes/statistics for the SQL databases that executes on a regular schedule?
Or is this something a DBA needs to setup?
Scott
K2 databases, maintenance needed?
+3
+9- Nintex Partner
The K2 databases are standard SQL databases so the basic SQL maintenance procedures would still apply. This especially holds true if your daily transaction load is high.
+3Any guides our standards on how the maintenance plans should be setup in SQL server? Or do we just use the defaults for the databases K2 uses?
+13What do you guys use for maintenance plan?
Rebuild Index Task -> Update Statistics Task (full scan)
+9- Nintex Partner
Normally you would follow your corporate IT standards on maintaining SQL databases.
In generally this would mean that you would plan your schedule on how the maintenance is done.
Activities would normally include creating a maintenance plan to do integrity checks and also to do maintenance on the indexes for performance (if inserts and deletes occur a lot).
I would recommend getting a book which provides some best practices on this. The one I normally use is from the pocket consultant series (SQL Server 2005 Administrator's Pocket Consultant).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.