Document your schedule for running data consistency checking and performance monitoring tools. Use 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 monitoring utilization |
|---|---|---|---|---|
master |
every night |
|||
TRD |
every weekend |
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 |
every hour |
ACT |
every weekend |
different tables “Round-robin” every night |
different tables “Round-robin” every night |
every hour |
