Monitoring SQL Replication

Discussion:

(too old to reply)

smeeta

2008-02-27 12:32:01 UTC

Hi,
I want to monitor the SQL replication so that whenever replication fails
it will send an alert. if replication fails, it's loging an event in event
viewer. but no alerts are being logged in Alerts view of SCOM server and i am
not getting any alerts.
Please help me..

Smeeta

Anders Bengtsson

2008-02-27 12:45:57 UTC

Permalink

Hi smeeta,

Have you imported the SQL MP?

If you have, and there still is no alert, then you can create a rule on your
own. But first check the if you have the SQL MP.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se

s> Hi,
s> I want to monitor the SQL replication so that whenever replication
s> fails
s> it will send an alert. if replication fails, it's loging an event in
s> event
s> viewer. but no alerts are being logged in Alerts view of SCOM server
s> and i am
s> not getting any alerts.
s> Please help me..
s> Smeeta
s>

smeeta

2008-02-27 13:00:02 UTC

Permalink

Hi Anders,
i have imported the SQL MP. And i am getting alerts for some of the
SQL job failure (related to some other application on that server). but
whenever replication is failing, i am not getting any alert.

should we go for monitor or rule for this?

Thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
Have you imported the SQL MP?
If you have, and there still is no alert, then you can create a rule on your
own. But first check the if you have the SQL MP.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se
s> Hi,
s> I want to monitor the SQL replication so that whenever replication
s> fails
s> it will send an alert. if replication fails, it's loging an event in
s> event
s> viewer. but no alerts are being logged in Alerts view of SCOM server
s> and i am
s> not getting any alerts.
s> Please help me..
s> Smeeta
s>

Anders Bengtsson

2008-02-27 13:09:55 UTC

Permalink

Hi smeeta,

Go with a rule that generate an alert for you.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se

s> Hi Anders,
s> i have imported the SQL MP. And i am getting alerts for some
s> of the
s> SQL job failure (related to some other application on that server).
s> but
s> whenever replication is failing, i am not getting any alert.
s>
s> should we go for monitor or rule for this?
s>
s> Thanks,
s> Smeeta
s> "Anders Bengtsson" wrote:
s>

Post by Anders Bengtsson
Hi smeeta,
Have you imported the SQL MP?
If you have, and there still is no alert, then you can create a rule
on your own. But first check the if you have the SQL MP.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se
s> Hi,
s> I want to monitor the SQL replication so that whenever replication
s> fails
s> it will send an alert. if replication fails, it's loging an event in
s> event
s> viewer. but no alerts are being logged in Alerts view of SCOM server
s> and i am
s> not getting any alerts.
s> Please help me..
s> Smeeta
s>

smeeta

2008-02-28 06:49:01 UTC

Permalink

Hi Anders,
i created an alert generating rule
-In the console, under Authoring, Management Pack Objects, Rules, created a
new rule
- Alert Generating Rules/Event Based/NT Event Log (Alert)
- selected my MP and clicked next
- Input a rule name and chose rule target, clicked next
- input the following expression
eventid equals 208
eventsource equals SQLSERVERAGENT
eventdscription contains "SellKeys" to get the alerts for the failure of
replication related to my application only.
- clicked next and create

is there anything that i am missing here? i am not geeting any clue for
anything wrong here.

Please help me..

Thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
Go with a rule that generate an alert for you.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se
s> Hi Anders,
s> i have imported the SQL MP. And i am getting alerts for some
s> of the
s> SQL job failure (related to some other application on that server).
s> but
s> whenever replication is failing, i am not getting any alert.
s>
s> should we go for monitor or rule for this?
s>
s> Thanks,
s> Smeeta
s>

Post by Anders Bengtsson
Hi smeeta,
Have you imported the SQL MP?
If you have, and there still is no alert, then you can create a rule
on your own. But first check the if you have the SQL MP.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se
s> Hi,
s> I want to monitor the SQL replication so that whenever replication
s> fails
s> it will send an alert. if replication fails, it's loging an event in
s> event
s> viewer. but no alerts are being logged in Alerts view of SCOM server
s> and i am
s> not getting any alerts.
s> Please help me..
s> Smeeta
s>

smeeta

2008-02-28 06:59:00 UTC

Permalink

i forgot to mention that ia am not getting any alert even after craeting ana
alert generating rule...

Post by smeeta
Hi Anders,
i created an alert generating rule
-In the console, under Authoring, Management Pack Objects, Rules, created a
new rule
- Alert Generating Rules/Event Based/NT Event Log (Alert)
- selected my MP and clicked next
- Input a rule name and chose rule target, clicked next
- input the following expression
eventid equals 208
eventsource equals SQLSERVERAGENT
eventdscription contains "SellKeys" to get the alerts for the failure of
replication related to my application only.
- clicked next and create
is there anything that i am missing here? i am not geeting any clue for
anything wrong here.
Please help me..
Thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
Have you imported the SQL MP?
If you have, and there still is no alert, then you can create a rule
on your own. But first check the if you have the SQL MP.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se
s> Hi,
s> I want to monitor the SQL replication so that whenever replication
s> fails
s> it will send an alert. if replication fails, it's loging an event in
s> event
s> viewer. but no alerts are being logged in Alerts view of SCOM server
s> and i am
s> not getting any alerts.
s> Please help me..
s> Smeeta
s>

Anders Bengtsson

2008-02-28 13:40:56 UTC

Permalink

Hi smeeta,

Take a look at this and see if it gives you a solution http://contoso.se/blog/?p=250
else try to remove some criterias, and start with only event ID.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se

s> i forgot to mention that ia am not getting any alert even after
s> craeting ana alert generating rule...
s>
s> "smeeta" wrote:
s>

Post by smeeta
Hi Anders,
i created an alert generating rule
-In the console, under Authoring, Management Pack Objects, Rules, created a
new rule
- Alert Generating Rules/Event Based/NT Event Log (Alert)
- selected my MP and clicked next
- Input a rule name and chose rule target, clicked next
- input the following expression
eventid equals 208
eventsource equals SQLSERVERAGENT
eventdscription contains "SellKeys" to get the alerts for the failure of
replication related to my application only.
- clicked next and create
is there anything that i am missing here? i am not geeting any clue
for anything wrong here.
Please help me..
Thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
Have you imported the SQL MP?
If you have, and there still is no alert, then you can create a
rule on your own. But first check the if you have the SQL MP.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se
s> Hi,
s> I want to monitor the SQL replication so that whenever
replication
s> fails
s> it will send an alert. if replication fails, it's loging an
event
in
s> event
s> viewer. but no alerts are being logged in Alerts view of SCOM server
s> and i am
s> not getting any alerts.
s> Please help me..
s> Smeeta
s>

smeeta

2008-02-29 10:45:01 UTC

Permalink

Hi Anders,
it didn't work for me. i had done the same way as you have metioned in
http://contoso.se/blog/?p=250 . but it was not working. then i tried with
only event id. but still it's not logging any alerts.

is any other way out ?

Thanks,
smeeta

Post by Anders Bengtsson
Hi smeeta,
Take a look at this and see if it gives you a solution http://contoso.se/blog/?p=250
else try to remove some criterias, and start with only event ID.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se
s> i forgot to mention that ia am not getting any alert even after
s> craeting ana alert generating rule...
s>
s>

Post by smeeta
Hi Anders,
i created an alert generating rule
-In the console, under Authoring, Management Pack Objects, Rules, created a
new rule
- Alert Generating Rules/Event Based/NT Event Log (Alert)
- selected my MP and clicked next
- Input a rule name and chose rule target, clicked next
- input the following expression
eventid equals 208
eventsource equals SQLSERVERAGENT
eventdscription contains "SellKeys" to get the alerts for the failure of
replication related to my application only.
- clicked next and create
is there anything that i am missing here? i am not geeting any clue
for anything wrong here.
Please help me..
Thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
Have you imported the SQL MP?
If you have, and there still is no alert, then you can create a
rule on your own. But first check the if you have the SQL MP.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se
s> Hi,
s> I want to monitor the SQL replication so that whenever replication
s> fails
s> it will send an alert. if replication fails, it's loging an
event
in
s> event
s> viewer. but no alerts are being logged in Alerts view of SCOM server
s> and i am
s> not getting any alerts.
s> Please help me..
s> Smeeta
s>

smeeta

2008-03-03 07:31:00 UTC

Permalink

Hi Anders,
i got the issue solved. now m getting email alerts and it's logging
alerts on SCOM server.

Thanks a lot for your help...

Thanks,
Smeeta

Post by smeeta
Hi Anders,
it didn't work for me. i had done the same way as you have metioned in
http://contoso.se/blog/?p=250 . but it was not working. then i tried with
only event id. but still it's not logging any alerts.
is any other way out ?
Thanks,
smeeta

Post by smeeta
Hi Anders,
i created an alert generating rule
-In the console, under Authoring, Management Pack Objects, Rules, created a
new rule
- Alert Generating Rules/Event Based/NT Event Log (Alert)
- selected my MP and clicked next
- Input a rule name and chose rule target, clicked next
- input the following expression
eventid equals 208
eventsource equals SQLSERVERAGENT
eventdscription contains "SellKeys" to get the alerts for the failure of
replication related to my application only.
- clicked next and create
is there anything that i am missing here? i am not geeting any clue
for anything wrong here.
Please help me..
Thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
Have you imported the SQL MP?
If you have, and there still is no alert, then you can create a
rule on your own. But first check the if you have the SQL MP.
--
Anders Bengtsson
Microsoft MVP - Operations Manager
http://www.contoso.se
s> Hi,
s> I want to monitor the SQL replication so that whenever replication
s> fails
s> it will send an alert. if replication fails, it's loging an
event
in
s> event
s> viewer. but no alerts are being logged in Alerts view of SCOM server
s> and i am
s> not getting any alerts.
s> Please help me..
s> Smeeta
s>

Continue reading on narkive:

Search results for 'Monitoring SQL Replication' (Questions and Answers)

replies

MySQL - What is it?

started 2006-07-04 04:14:24 UTC

programming & design

replies

How many hours per day should I study to get my certification?

started 2007-04-30 14:57:10 UTC

programming & design

replies

exactly wat does sql server do????