SQL Server DBA Daily Checklist
DBA Checklist is a regular set of administrative checks on a SQL Server that help to identify less than optimal performance before it becomes a problem.
Three sections of the DBA checklist:
- perforamnce, job failures, disk space, backups, connectivity, plus any other environment specific items: mirroring, clustering, replication
- record issues, and resolutions
- confirmation section, signed and dated
If several DBAs are involved, have them collaborate to create a checklist more comprehensive than any of the individual lists.
Examples for DBA Morning Checklist Section 1:
- Backups
- Check for backup emails
- How long did the backup take to run (database backup duration)
- Verify that all databases are being backed up according to a maintenance plan
- Disk free space - Note significant variations from previous check. Log files may be affected drammatically by monthly jobs
- Job failures - filter job activity for failures
- System checks - Look in sql logs for any critical errors
- Performance
- Check performance statistics on all servers
- Check that counters are in normal range on all production servers
- Connectivity
- Verify the customer application can get data from the database
- Verify acceptable speed of access data
- Replication - Verify that the each publication and distributor is running for each subscription
Some things this kind of morning checklist can help find:
- High cpu usage (near 100%)
- broken replication
- connectivity problems
- space issues
- archive of past issues can help solve future issues quicker
Fresh copy to be cached until 7:51:24 AM |
