Alert when Sqlserver Instances stops.

Question

Alert when Sqlserver Instances stops.

Saravanan T

SSCrazy

Points: 2506
More actions
March 22, 2010 at 9:03 am

#139517

Hi,
Is it possible to get a alert when one of my instance or Sql server services get stops???
Regards,
Saravanan

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

Yes. There are products that will monitor that kind of thing for you. I've used "What's Up Gold" for that kind of monitoring before. It has several competitor products, and they all have advantages and drawbacks.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

WayneS SSC Guru Points: 95460 More actions · Answer 2

I can't think of any way that a specific server can alert you that it's services have shut down. You will need to use a process where an external server monitors it, such as the third party tools that GSquared mentions.

Now if you want to know when it starts back up, you could create a job with a schedule set to run when the SQL Server Agent starts to send an email/alert, etc.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

MannySingh SSChampion Points: 12465 More actions · Answer 3

use NETIQ. we use it for monitoring stuff. Also IBM Tivoli is helpful. Or check this:

http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ServiceStatusMon&referringTitle=AutomatedDBA

Maninder
www.dbanation.com

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 4

You could create an ssis package and try and connect, if it does not respond the step fails and you then have an on fail step to insert into a table. I use a foreach loop container and check all the prod servers this way, if one does not respond an email alert is sent.

Andrew

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

We have NetIQ and another in-house built app to perform those duties.

I have also tested What's Up Gold and Diagnostic Manager. Both seem fine as well.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events