SAP recommends that you keep a calendar of regularly scheduled maintenance activities.
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 SAP ASE and Backup Server
Running the update statistics command (see Performance and Tuning Series: Improving Performance with Statistical Analysis > Using the set statistics Commands)
Examining auditing information, if the auditing option is installed
Recompiling stored procedures
Monitoring resource utilization of the server machine