BlankHi,

Anyone knows a good utility that could monitor SQL services on a server?
sometime sqlserver agent service stopped caused all jobs can not be
executed, SQL mail also rely on this service so I can't get notification on
that. any performance monitoring tools are also welcome.

Thanks,

Chong

When you are looking for a complete package take a look at Microsoft
operations manager MOM...

there is also a workgroup edition for a max of 10 servers.

There are management packs for sql server.

http://www.microsoft.com/mom/default.mspx

And when any service on the computer is stopped without a reason MOM creates
a warning...

Best regards

Floris


"Jack" <chongh.hc (AT) gmail (DOT) com> schreef in bericht
news:eyIY9tayFHA.908 (AT) tk2msftngp13 (DOT) phx.gbl...

if it's just 1 service on 1 server you can set recovery actions on the
service in computer manangement:
write a script with a net send or use fi blat to generate an e-mail

Regards

"Floris van Haaster" wrote:

thanks, i'll take look at it.

"Floris van Haaster" <floris (AT) NO-SPAM-datasmit (DOT) nl> wrote

I will monitor couple of services on multiple servers, I will see how MOM
can help me on this.

thanks for your reply!

"Zekske" <Zekske (AT) discussions (DOT) microsoft.com> wrote

Jack,

Microsoft - MOM 2005
NETIQ - AppManager
Quest - Spotlight for SQL Server --check this one out first - most
comprehensive and easy to use

HTH

Jerry
"Jack" <chongh.hc (AT) gmail (DOT) com> wrote

It should be noted that there is not a Management Pack available for SQL
Server 2005 yet.
Despite Microsoft's promise that no server would be released without one ....

"Jerry Spivey" wrote:

I thought it had been released but
http://www.microsoft.com/downloads/d...displaylang=en
does indicate that it'll becoming soon. I'd suggest keeping your eye on that
page.

--
Sincerely,
Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Randy Johnson" <RandyJohnson (AT) discussions (DOT) microsoft.com> wrote