DBA TASKS FOR DAILY / WEEKLY / MONTHLY

DBA TASKS FOR DAILY / WEEKLY / MONTHLY

Daily Tasks:

The following tasks should be completed on a daily basis:
Check to make sure the SQL Server is still online and that you still have connectivity.
Check the NT and SQL Server logs for any errors or problems.
Ensure that no SQL Server job has failed.
Resolve any problem tickets.
Close any outstanding change tickets.
Perform the necessary backups, whether transactional or complete.
Check the general health of the server (space, CPU utilization, memory) to confirm there are no issues.
Track locking issues, including deadlocks, blocking, and lock timeouts.




Weekly Tasks:

The following tasks should be completed on a weekly basis:
Perform necessary database backups.
Remove any unneeded space from the transaction log and data files.
Perform any necessary index tuning, including defragmenting the indexes.
Execute UPDATE STATISTICS if auto-update statistics has been turned off.




Monthly Tasks:

The following tasks should be completed on a monthly basis:
Perform necessary database backups (including a complete backup of the OS and supporting third-party application files).
Apply any patches or service packs for SQL Server.
Run System Monitor to confirm that your server is operating close to its baseline. Update your baseline documentation to reflect this month’s numbers.
Perform a complete system restore of the server’s database onto a new server from a random day. Check the health of the restored database afterward by running DBCC CHECKDB.
Run sqldiag.exe on your server and document the results into a central repository.
Test your alerts to confirm that they still work.