Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alert when Sqlserver Instances stops. Expand / Collapse
Author
Message
Posted Monday, March 22, 2010 9:03 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 4:51 AM
Points: 500, Visits: 721
Hi,
Is it possible to get a alert when one of my instance or Sql server services get stops???


Regards,
Saravanan
Post #887433
Posted Monday, March 22, 2010 9:27 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #887453
Posted Monday, March 22, 2010 9:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 6,579, Visits: 8,848
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
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, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #887466
Posted Monday, March 22, 2010 9:56 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, January 2, 2014 10:30 AM
Points: 646, Visits: 731
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
Post #887472
Posted Monday, March 22, 2010 3:20 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 11:41 AM
Points: 414, Visits: 2,881
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



Post #887718
Posted Monday, March 22, 2010 3:32 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:25 PM
Points: 21,093, Visits: 14,773
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #887730
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse