Re: SQL Server 2000 Uber Monitoring Tools - a request for info

Tech-Archive recommends: Fix windows errors by optimizing your registry

not a quick answer , but I would definately look @ DMO which can be accessed
using VBScrip via COMt. Very useful for doing "For Each" type of
functionality you want

Bit of a learning curve but worth the investment

Also MOM is quite good for this , but I'm guessing too much of an invesment
for 30 servers.

cheers,
Andy.


<quackhandle1975@xxxxxxxxxxx> wrote in message
news:1140710861.936265.229580@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I am looking to evaluate SQL Server 2000 monitoring


tools for the SQL
Server setup we have here. I have been looking at various tools however
I was wondering if anyone out there knows of any tools that will
automatically do the following tasks that are currently performed
manually (i.e. - Me, every morning!):

* Check all SQL Servers are up and running
* Check all SQL Server Agents are running
* Check database status (egg - flag for corrupt or 'In Load' db's)
* Check for deadlocking
* Check SQL Server error logs
* Check all SQL jobs for any errors.
* Monitor any replication, log shipping, etc

I know people will say that SQL Server does these things already and
that I should stop being lazy, however trying to "eyeball" over 30
servers that contain over 20 databases and their related jobs can be
quite time consuming. Basically what would be ideal would be a tool
that a report can be run once a day (or on demand) that can inform me
the status of the servers/database and any errors that I can quickly
deal with as well as the points mentioned.

Many thanks

qh



.

Relevant Pages