469,087 Members | 1,264 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,087 developers. It's quick & easy.

Looking for tools to monitor sql and applications

reg

I am looking for the right tools to do application monitoring.
I'm hoping to find one single tool that can do the entire job but if
it does not exist then a few monitoring apps would do as well.

I need the ability to do the standard things like testing for ping,
checking for windows services running and restarting them after some
threshold is met, and wmi.

Some of the more tricky things I need it to do are:
* Parse log files looking for specific error codes, and the ability to
set an alert only if it sees that error X times over some period of
time.

* Run custom slq queries like row counts and max values returned from
a query and if that condition is met X times over some period of
time.

* Run an external app that does its own custom testing and act on its
results, which could be to parse the result file from the app.

Keep in mind cost is not the isssue right now - so this can be
freeware to some type of enterprise solution that our company can use.
Does anyone know of any tools that you can point me towards?

Thanks...


Jul 20 '05 #1
1 1157
(re*@yahoo.com) writes:
I am looking for the right tools to do application monitoring.
I'm hoping to find one single tool that can do the entire job but if
it does not exist then a few monitoring apps would do as well.

I need the ability to do the standard things like testing for ping,
checking for windows services running and restarting them after some
threshold is met, and wmi.

Some of the more tricky things I need it to do are:
* Parse log files looking for specific error codes, and the ability to
set an alert only if it sees that error X times over some period of
time.

* Run custom slq queries like row counts and max values returned from
a query and if that condition is met X times over some period of
time.

* Run an external app that does its own custom testing and act on its
results, which could be to parse the result file from the app.

Keep in mind cost is not the isssue right now - so this can be
freeware to some type of enterprise solution that our company can use.
Does anyone know of any tools that you can point me towards?


Have you looked at Microsoft Operations Manager? I can't tell that it
does all you want, but MOM is the tool Microsoft presents when you
need to monitor many servers. (It is not really clear from your post
that is what you want, though.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Charlie Martin | last post: by
11 posts views Thread by Charlie Martin Beta program | last post: by
10 posts views Thread by santiago538 | last post: by
2 posts views Thread by Mike | last post: by
12 posts views Thread by amogan | last post: by
2 posts views Thread by =?Utf-8?B?Um9oaXQ=?= | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.