February 14, 2005 at 9:42 am
So the boss says, "Check the following databases on the following servers and let me know how they are doing?". Given an open ended directive, what kinds of things should I be looking for? I have set up jobs on all requested servers to run stored procedures I created to list sizes of databases, history of jobs, history of backups, and fragmentation levels of tables in the requested databases.
What would you add, remove, etc.? Right now he is only asking for info on a small number of servers (~7) and a handfull of db's on each server. My goal is to set up weekly jobs whose output I can query each Monday morning to prepare a Server Health Report.
Gordon
Gordon Pollokoff
"Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones
February 14, 2005 at 9:53 am
I think you did cover everything. But something you might want to look at is any locking/blocking in the databases. This will give you a good idea about the health of the system.
February 14, 2005 at 11:23 am
I would add the free space on the data and system drives and if you want to be the best add a WMI or VBscript job that will check on the red and yellow dots in the event logs and send you an email. Or create admin alerts to send you an email
Do not add to much in the report itself: the more info is in there the fewer chances someone (non-technical boss) will notice something is wrong. The report should also say are the readings normal or "off"
Yelena
Regards,Yelena Varsha
February 15, 2005 at 11:40 am
I would also add the status of a db, like: Offline/Suspect, etc
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply