Keep a calendar of regularly scheduled maintenance activities; list any of the procedures you perform at your site:
Using dbcc to check database consistency
Backing up user and system databases
Monitoring the space left in transaction logs (if this is not done automatically)
Dumping the transaction log
Examining the error log contents for Adaptive Server, Backup Server, and Adaptive Server Monitor
Running the update statistics command (see Chapter 1, “Using the set statistics Commands,” in Performance and Tuning Series: Improving Performance with Statistical Analysis)
Examining auditing information, if the auditing option is installed
Recompiling stored procedures
Monitoring resource utilization of the server machine
