MS SQL Server Tools - SQL Server 2000 Uber Monitoring Tools

Author

SQL Server 2000 Uber Monitoring Tools - a request for info

quackhandle1975@yahoo.co.uk

2006-02-25, 9:45 am

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

David Gugick

2006-02-28, 8:29 pm

quackhandle1975@yaho
o.co.uk wrote:
> 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

You may want to check out Quest's new Spotlight on SQL Server Enterprise
which will be released very soon. It provides a single dashboard for all
your SQL Servers. If you'd like, I can put you in touch with one of our
engineers for more information about the product and get you a demo.

I am affiliated with Quest Software.

Email me directly (take the nospam out of the email address) and I'll
put you in touch with the correct person.

--
David Gugick - SQL Server MVP
Quest Software

Andy Ball

2006-03-07, 8:24 pm

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@yaho
o.co.uk> wrote in message
news:1140710861.936265.229580@z34g2000cwc.googlegroups.com...
> 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
>

Sponsored Links