Author |
Topic |
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-01-19 : 12:23:31
|
Is there any pagers/beepers are available for SQL Server monitoring.I mean to get alerts like job failures, system shutdown...etc |
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-19 : 12:48:36
|
send an ssms to your cell phone via email.have a look at this: http://www.sms411.net/2006/07/how-to-send-email-to-phone.html |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
Kristen
Test
22859 Posts |
Posted - 2010-01-19 : 13:10:13
|
I think ServersAlive is worth a look. It can do Paging / Text messaging (although that may be a bit hard to set up if its just a single server) but it will also monitor Web servers, Disk space shortage, and all sorts of other things.Freeware for up to 10 monitor-thingies (I think) |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-19 : 13:15:48
|
I appreciate the O/P is in USA, but my $0.02-worth is that "Just use Database Mail to send out the alerts to your cell phone." may be a USA-only solution?My understanding is that USA cell phones are a) pay-to-receive-SMS and b) often have an associated email address that will forward to the phone (although I read that the "priority" of such messages can be suspect!)Over here SMS Text is pay-to-send and free to receive (unless you are out-of-area, e.g. abroad, in which case recipient pays the surcharge for out-of-area). Although there are plenty of Bureaus which provide 07123456789@MySMSBureau.com style mail-to-SMS gateways (buy credits, and then use up at will) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
Kristen
Test
22859 Posts |
Posted - 2010-01-19 : 13:25:59
|
"I never see a bill."I like the sound of that! but for cellphones over here there would no corresponding "Email Address" to get an SMS to the phone (as that would have no method to get the "sender-to-pay"), hence you have to use a bureau where you have already purchases credits - which may make the task a little harder Twitter may be another route for folk with iPhone type devices that can have APPs running and do cool stuff on receipt of a message. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-01-19 : 15:57:00
|
Thanks for all,I have successfully tested database email alerts to my cellphone(AT&T). Sofar I configured job failure email alerts to cellphone.Can I set up other things like, SQL Server down, dis space issue etc...if yes how can we do that? |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2010-01-19 : 16:18:03
|
I mean we don't have any third party tool to monitor CPU, Disk space, Service down. Is there any way to get these alerts to my Cellphone using SQL Server 2005 SSMS |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
Kristen
Test
22859 Posts |
Posted - 2010-01-20 : 02:11:23
|
"I mean we don't have any third party tool to monitor CPU, Disk space, Service down. Is there any way to get these alerts to my Cellphone using SQL Server 2005 SSMS"ServersAlive will do those (I'm pretty sure), and it can send an Email, so if that can trigger an alert on your phone, maybe that will do the trick?You could write BATCH routines, and trigger them from SSMS, but I can't think of a way for SSMS to detect "service down" 'coz it needs the database service running to get its schedule - although you could obviously use the Windows scheduler instead for those, but I reckon they need to be on a different server in case the SQL box itself is down. ServersAlive will just make an "Are you alive" test of the SQL box, from a remote location(s).Google should find it - they are in Australia I think. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-20 : 08:40:02
|
We use WhatsUp Gold |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-20 : 09:21:05
|
If you're on sql server 2008 you can use Data Collection and Policy Management to achieve some of the tasks but not all...MOM, SCOM or some other monitoring tools are probably what you're looking for. Or the open source Munin for example...- Lumbagohttp://xkcd.com/327/ |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-20 : 09:24:35
|
Sorry, I ment to say Nagios instead of Munin...Munin is a graphing tool. And I also heard that ZenOSS is good...- Lumbagohttp://xkcd.com/327/ |
|
|
alexsolo
Starting Member
1 Post |
Posted - 2010-01-20 : 19:11:37
|
You might want to take a look at a project that we're working on called PagerDuty ([url]www.pagerduty.com[/url]). It sends phone call and SMS alerts in response to incoming email.We've got some other fun features too: automatic escalation (your co-worker gets the call if you're unable to pick up) and on-call rotations (automatically route calls to your phone this week, and to your co-worker next week).We're always looking to add more features to PagerDuty, so please let us know what you think!Alex SolomonPagerDuty Co-founderwww.pagerduty.com |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-20 : 19:54:29
|
quote: Originally posted by alexsolo so please let us know what you think!
I think you only posted to redirect traffic to your site. |
|
|
|