Daily Check List

I need to create daily check list for SQL 2000. Here is what I have done:

1. Check the connectivity of each server over the network. (Ping/open Enterprise Manager and proof connection)
2. Check whether the services are running for each server. (Green light)
3. Check the scheduled tasks on the production servers are running normally. Enterprise Manager of each server or your email (Set up SQL Mail to notify you).
4. Check the hard disk space available on the SQL Servers.
5. Check all the database and transaction log space on each server. If the database or transaction log space runs out, the transactions will fail.
6. Check NT event Logs for any error messages.
7. Check SQL Error Logs for any errors occurring within SQL Server.

My question is: any other tips & ideas for every day routine?

Thank in advanced!

You've got a great start here. The log checks are an important step that many shops miss. On a daily basis, you also want to check your backups, and the status of replication and clustering if you have that installed as well. You'll pick some of that up in the logs, but you may want to check them independently as well. At my shop we also include a check on the running processes to make sure we don't have any run away queries, but that all depends on the size of your shop and the number of applications you have running.

You may want to incorporate all of these checks into a single place. The two processes I've seen are to write a set of scripts to gather all the information into a monitoring database, or to purchase a software package that will do the same thing for you.

Buck