SQL Server DBA – Daily Checklist

Database administrators’ responsibility to take care the database and database environment and they used to take appropriate action whenever a task comes. Apart from doing their job, this what I find that each DBA must do every day:

1)       Check OS Event Logs and SQL Server Logs for unusual events.

2)      Verify that all scheduled jobs have run successfully.

3)      Confirm that backups have been made and successfully saved.

4)      Monitor disk space to ensure your SQL Servers won’t run out of disk space.

5)      Throughout the day, periodically monitor performance using both System Monitor and Profiler/SQL Trace.

6)      Regularly monitor and identify blocking issues.

7)      Keep a log of any changes you make to servers, including documentation of any performance issues you identify and correct.

8)      Create SQL Server alerts to notify you of potential problems. Take action as needed.

9)      Regularly restore backups to a test server in order to verify that you can restore them.