1.Check the SQL Error logs for any errors that may of occured overnight.
2.Check available physsical Diskspace (stored procedure)
3.Check the Event Viewer.
4.Check the jobs for failed completion.
5.Check backups and log sizes.
6.Monitor performance with PERFMON
7.Check for outstanding active or blocked transactions. (stored procedure)
2.Run Integrity checks
1.Perform monthly security audits on all logins and users to SQL Server.
2.Perform physical disk fragmentation on data drives.
7 Reviews For This Service