Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
 Posted - 2009-04-21 : 06:02:40
|
| Hi all,I was surprised to find no post when searching on "configure replication alerts", so I guess I must be missing something obivous, if no-one else has asked about it, but here goes.I have Publisher-Distributor-Subscriber implementation of transaction replicaiton on several large tables. The subscriber make use of the data for BI ETL. I would like to be able to moitor and alert if latency exeeeds a threshold (1 hour). All of this looks good - in repl monitor, I can set the threshold, and configure alerts. But, I doesn't seem to be firing. I've done some googling, and have seen some comments about it not working when you use the default message, so I tried with a customer user message as well.Any thoughts/pointers?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-21 : 09:47:44
|
| Are you using the proc sp_replmonitorsubscriptionpendingcmds to get pending commands to alert you?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2009-04-21 : 12:50:39
|
| At the moment, I am trying to use the SQL built-in replication alerting in the GUI: in REPLICATION MONITOR; on the PUBLICATION, in the WARNINGS AND ALERTS TAB, using CONFIGURE ALERTS, choosing the REPLICATION WARNING: TRANSACTIONAL REPLICATION LATENCY (THRESHOLD: LATENCY) alert.I have had some success by changing from SQL Server Event Alert (which I expected to work), to using SQL SERVER PERFORMANCE CONFITION ALERT, although I am still trying to interpret the results, as now we are seeing too many alerts - I am not sure what the VALUE setting is for the section on the GUI*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
Zaheer
Starting Member
2 Posts |
Posted - 2010-05-11 : 22:40:42
|
| I've the same scenario, Transactional replication in SQL Server 2005 with SP3 + HF 4266, the Latency Alert is not sending any notification when it meet or exceeds the defined threshold. Any help would be great and apprecaite your time, thanks. |
|
|
|
|
|
|
|
|
Configure Replication Alerts for Trans Rep