Home Forums SQL Server 2008 SQL Server 2008 Administration Proactive sql dba activities for Production Databases RE: Proactive sql dba activities for Production Databases
Suresh B.
SSC-Insane
Points: 22986
More actions
January 16, 2013 at 11:58 pm
#1578102
Monitor blocking
Monitor free space in the data, log and disks. Increase the DB, Log file size when required to avoid auto-growth
Alerts for job, log shipping, replication, etc.
Monitor log file size/growth
Alerts for high memory, cpu utilization.