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 12»»

Program to install on database servers Expand / Collapse
Author
Message
Posted Monday, December 28, 2009 6:50 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
Hi,

I need a program that i can install on my database servers so that if the server goes down i receive a e-mail message and a message on my mobile phone.

Do yoiu know any app that can do this? free if possible :)

Thank you
Post #839392
Posted Monday, December 28, 2009 7:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:34 PM
Points: 12,755, Visits: 31,122
i just googled "free system monitoring software" and found lots of stuff;

you want to watch for more than just the SQL server service being up or down; you've also got to see if there is a network issue, or even if the whole server is offline/down.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #839402
Posted Monday, December 28, 2009 8:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:42 PM
Points: 14,840, Visits: 27,315
It's not free but I love Idera's Diagnostic Manager. It'll do what you want and more. You also might want to take a look at Red Gate's SQL Alert. It's focused on exactly what you're looking for.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #839435
Posted Monday, December 28, 2009 9:02 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
I don't need to see if my SQL Server service is down...
what i need to know is if the server it self is down
Post #839461
Posted Monday, December 28, 2009 9:11 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:05 AM
Points: 41,572, Visits: 34,500
river1 (12/28/2009)
I don't need to see if my SQL Server service is down...
what i need to know is if the server it self is down


In that case, you don't want something installed on the database servers, as it'll be kinda hard for a program installed on a server to notify you that the server it is installed on is down.
You need a centralised diagnostic server. Get demos of the ones that people have mentioned in this thread and try them out.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #839472
Posted Monday, December 28, 2009 9:48 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
But , with this apps can people be notified by this two ways? e-mail and mobile phone message?
Post #839493
Posted Monday, December 28, 2009 9:51 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 10:04 AM
Points: 15,442, Visits: 9,590
river1 (12/28/2009)
But , with this apps can people be notified by this two ways? e-mail and mobile phone message?


It depends on the product. Some yes, some no. Search them online, you can find out what features they have that way.


- 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 #839494
Posted Monday, December 28, 2009 10:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:29 PM
Points: 32,834, Visits: 14,975
I've used Servers Alive and What's Up gold for this. They both work. Not free, but they work.

Note that it's likely worth paying a little for something if you want to ensure it's up.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #839503
Posted Monday, December 28, 2009 10:24 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, April 07, 2014 10:25 AM
Points: 715, Visits: 1,018
ok guys thank you.
I will study the apps
Post #839510
Posted Monday, December 28, 2009 11:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:42 PM
Points: 14,840, Visits: 27,315
river1 (12/28/2009)
But , with this apps can people be notified by this two ways? e-mail and mobile phone message?


Both of the ones I mentioned work with either. After all, it's nothing to send an email to a phone, just like to an email address.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #839538
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse