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 |
