online notification

Question

online notification

mobasha

SSCertifiable

Points: 5334
More actions
August 27, 2008 at 12:45 pm

#124996

hello all.
am trying to find a way to get an online notification on SQL Server performance.
can u share ur experiance in this field and advise the best way to do it.
thanks.
..>>..
MobashA

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

I'm not sure what you mean by an online notification. Do you mean having data on a web page, or do you mean an e-mail, or something else?

- 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

mobasha SSCertifiable Points: 5334 More actions · Answer 2

i mean that like when the CPU hits 90% an email notification will be send to the administrator or when there is a dead lock...etc..

..>>..

MobashA

GSquared SSC Guru Points: 260824 More actions · Answer 3

I think Notification Services can do that.

- 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

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 4

You can set performance counter alerts in Alerts to let you know things, but be careful. The CPU will jump to 100% often on a busy server, and that doesn't mean something is wrong. If it's 100% for more than 4 or 5 minutes, I might get concerned.

Quest, sqlSentry, Idera, Microsoft all make products that can help alert you. Really you need a good third party solution to prevent constant alerts.

mobasha SSCertifiable Points: 5334 More actions · Answer 5

i was thinking of Idera have u tried it?

..>>..

MobashA

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 6

I have used MOM briefly and What's Up Gold, but not Idera. You can download an eval and give it a try. See what you think. Most of these package are similar, just need to pick one that works for you.

homebrew01 SSC Guru Points: 55548 More actions · Answer 7

mobasha (8/30/2008)
i was thinking of Idera have u tried it?

I used different Idera products at my previous job (Diagnostic Manager, SQLSafe, Compliance Manager). They were pretty good. As suggested, get the free demos from various companies and see which you like best for the money. Idera will discount quite a bit from "retail" price. Although their yearly maintenance is based on a percentage of MSRP, not what you paid the first year.