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 4, “Using the set statistics Commands,” in Performance and Tuning: Monitoring and Analyzing)
Examining auditing information, if the auditing option is installed
Recompiling stored procedures
Monitoring the resource utilization of the server machine
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
