What are the critical aspects of SQL Server that a Database Administrator (DBA) should check on a daily basis? Each morning you should check the following items:
- Verify servers are available and can be accessed
- Check Windows Event Logs for unusual events
- Check SQL Server Logs for unusual events
- Review the status of Cluster nodes, Log Shipping, Replication, AlwaysOn, or Mirroring on both the primary and secondary instances and troubleshoot as needed. If a failover has occurred, investigate root causes immediately
- Verify that all SQL Server scheduled jobs have run successfully
- Confirm that backups have run successfully and backup files have been saved to a secure location
- Monitor disk space on your SQL Servers so they have at least 10% free space on all drives
- Monitor performance using both System Monitor and Profiler/SQL Trace.
- Regularly monitor and identify potential blocking issues.
- Document any changes you make to your servers.
- Create automated SQL Server alerts e-mailed to you about any actions required.
- Find time to learn something new as a DBA.
Do you have any ideas on additional items to add to this list?