Maintenance procedures

Document your schedule for running data consistency checking and performance monitoring tools, using a table similar to this example:

Database name

Frequency of dbcc checkdb and dbcc checktable

Frequency of dbcc checkalloc and dbcc tablealloc

Frequency of update statistics

Frequency of dbcc checkstorage

Frequency of monitoring utilization

master

every night

every night

TRD

every weekend

different tables “round-robin” every night

different tables “round-robin” every night

different tables “round-robin” every night

every hour

CIS

every weekend

different tables “round-robin” every night

different tables “round-robin” every night

different tables “round-robin” every night

every hour

ACT

every weekend

different tables “round-robin” every night

different tables “round-robin” every night

different tables “round-robin” every night

every hour