Program to install on database servers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Program to install on database servers

11 posts, Page 1 of 2

1 2 »»

Program to install on database servers

Rate Topic

Display Mode

Topic Options

Author

Message

river1

Posted Monday, December 28, 2009 6:50 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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

Lowell

Posted Monday, December 28, 2009 7:11 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 11,645, Visits: 27,745

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

Grant Fritchey

Posted Monday, December 28, 2009 8:28 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:57 AM
Points: 13,383, Visits: 25,182

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

river1

Posted Monday, December 28, 2009 9:02 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

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

GilaMonster

Posted Monday, December 28, 2009 9:11 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 37,739, Visits: 30,012

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

river1

Posted Monday, December 28, 2009 9:48 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

But , with this apps can people be notified by this two ways? e-mail and mobile phone message?

Post #839493

GSquared

Posted Monday, December 28, 2009 9:51 AM

SSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571

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

Steve Jones - SSC Editor

Posted Monday, December 28, 2009 10:13 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:32 AM
Points: 31,433, Visits: 13,747

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

river1

Posted Monday, December 28, 2009 10:24 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:56 AM
Points: 679, Visits: 953

ok guys thank you.
I will study the apps

Post #839510

Grant Fritchey

Posted Monday, December 28, 2009 11:45 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:57 AM
Points: 13,383, Visits: 25,182

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 »

11 posts, Page 1 of 2

1 2 »»

Permissions