SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Paging system for server monitoring
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

laddu
Constraint Violating Yak Guru

USA
331 Posts

Posted - 01/19/2010 :  12:23:31  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 01/19/2010 :  12:48:36  Show Profile  Visit russell's Homepage  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36941 Posts

Posted - 01/19/2010 :  13:02:28  Show Profile  Visit tkizer's Homepage  Reply with Quote
Just use Database Mail to send out the alerts to your cell phone.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/19/2010 :  13:10:13  Show Profile  Reply with Quote
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)
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/19/2010 :  13:15:48  Show Profile  Reply with Quote
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)
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36941 Posts

Posted - 01/19/2010 :  13:21:23  Show Profile  Visit tkizer's Homepage  Reply with Quote
We have our alerts going to work cell phones, so it's work that sends and receives it. I never see a bill.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/19/2010 :  13:25:59  Show Profile  Reply with Quote
"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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36941 Posts

Posted - 01/19/2010 :  13:27:15  Show Profile  Visit tkizer's Homepage  Reply with Quote
Well laddu appears to be in the US, but I see your point.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

laddu
Constraint Violating Yak Guru

USA
331 Posts

Posted - 01/19/2010 :  15:57:00  Show Profile  Reply with Quote
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?
Go to Top of Page

laddu
Constraint Violating Yak Guru

USA
331 Posts

Posted - 01/19/2010 :  16:18:03  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36941 Posts

Posted - 01/19/2010 :  17:11:59  Show Profile  Visit tkizer's Homepage  Reply with Quote
We use Microsoft MOM/SCOM for all of SQL Server monitoring. You'll need to write custom scripts for certain things without a tool like that.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/20/2010 :  02:11:23  Show Profile  Reply with Quote
"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.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 01/20/2010 :  08:40:02  Show Profile  Visit russell's Homepage  Reply with Quote
We use WhatsUp Gold
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/20/2010 :  09:21:05  Show Profile  Reply with Quote
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...

- Lumbago
http://xkcd.com/327/
Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 01/20/2010 :  09:24:35  Show Profile  Reply with Quote
Sorry, I ment to say Nagios instead of Munin...Munin is a graphing tool. And I also heard that ZenOSS is good...

- Lumbago
http://xkcd.com/327/

Edited by - Lumbago on 01/20/2010 09:30:00
Go to Top of Page

alexsolo
Starting Member

Canada
1 Posts

Posted - 01/20/2010 :  19:11:37  Show Profile  Reply with Quote
You might want to take a look at a project that we're working on called PagerDuty (www.pagerduty.com). 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 Solomon
PagerDuty Co-founder
www.pagerduty.com
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 01/20/2010 :  19:54:29  Show Profile  Visit russell's Homepage  Reply with Quote
quote:
Originally posted by alexsolo

so please let us know what you think!


I think you only posted to redirect traffic to your site.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000