Daily Checklist

I always keep this checklist with me 

 1. Check OS Event Logs and SQL Server Logs for all or specific events.

 2. Verify that all scheduled jobs have run successfully, if failed try to solve them depending on   the

        Type of job and priority.

 3. Check that backups have been made and successfully saved to a secure location.

 4. Monitor disk space to ensure your SQL Servers won’t run out of disk space. For best performance, all    disks should have 15% or more of free space. I keep a log of tempdb, and all user databases mdf and ldf in excel  

 5.  Regularly monitor and identify blocking issues. ( I do SP_WHO2) and

     SELECT * FROM sys.sysprocesses

 6. Create SQL Server alerts to notify you of potential problems like space alerts on all drives , and have them e-mailed to you.

 7. Regularly restore backups to a test server in order to verify that you can restore them. You don’t need to restore all backups every day, but do so often to ensure that you are confident you have good backups.

8.check and monitor index fragmentation %