How can I know the "SQL Server" Service is down ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cpchan - 30 Sep 2007 07:46 GMT

Dear,

How can I make a SQL Server able to send me an email alert if its SQL Server
Service and/or SQL Server Agent Service is down automatically ?
SQL 2005 Database Mail and SQL 2000 SQL Mail can't do that because they can
monitor themselves.

Are there any other way to monitor them ? Either from Microsoft Windows
system or third party softwares.

Reply to this Message

Mark Yudkin - 30 Sep 2007 09:50 GMT

The simplest solution is to configure MOM (assuming you have deployed it).

Otherwise you need to do this in Windows. In the Computer Management -
Services node, display the properties pages of the services of interest and
configure the recovery page.

> Dear,
>
[quoted text clipped - 7 lines]
> Are there any other way to monitor them ? Either from Microsoft Windows
> system or third party softwares.

Reply to this Message

cpchan - 30 Sep 2007 14:13 GMT

Dear Yudkin,

What does MOM stand for ?
Please tell me, thanks a lot.

> The simplest solution is to configure MOM (assuming you have deployed it).
>
[quoted text clipped - 13 lines]
> > Are there any other way to monitor them ? Either from Microsoft Windows
> > system or third party softwares.

Reply to this Message

Dan Guzman - 30 Sep 2007 14:40 GMT

> What does MOM stand for ?

Microsoft Operations Manager. See
http://technet.microsoft.com/en-us/opsmgr/bb498244.aspx

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

> Dear Yudkin,
>
[quoted text clipped - 20 lines]
>> > Are there any other way to monitor them ? Either from Microsoft Windows
>> > system or third party softwares.

Reply to this Message

cpchan - 30 Sep 2007 15:29 GMT

Thanks

> > What does MOM stand for ?
>
[quoted text clipped - 31 lines]
> >> > Are there any other way to monitor them ? Either from Microsoft Windows
> >> > system or third party softwares.

Reply to this Message

bass_player [SBS-MVP] - 30 Sep 2007 23:20 GMT

Or (the poor man's approach) you can also write a WMI script using VBScript
that monitors the SQL Server service and sends an email when it goes down.

> Thanks
>
[quoted text clipped - 37 lines]
> Windows
>> >> > system or third party softwares.

Reply to this Message