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 |
|
suresha_b
Yak Posting Veteran
82 Posts |
 Posted - 2008-08-13 : 08:12:59
|
| Transactional replication latency alert is not firing. What could be the reason?Latency is exceeding the threshold. "Performance cretical" is displayed in the Replication Monitor. But alert is not firing. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-13 : 22:59:51
|
| How did you configure the alert? |
 |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2008-08-14 : 00:52:17
|
| An alert named "Replication Warning: Transactional replication latency (Threshold: latency)" was already there in the distributor for error number 14161. I just selected "Notify operators" under response.If I manually raise the error as follows, it sends email.raiserror(14161,10,1, '0', '30', 'Testing') |
|
|
|
Zaheer
Starting Member
2 Posts |
Posted - 2010-05-11 : 22:43:55
|
| I've the same scenario, Transactional replication in SQL Server 2005 with SP3 + HF 4266, the Replication Warning Latency Alert is not sending any notification when it meet or exceeds the defined threshold. Alert history shows 0 occurrences. Any help will be apprecaited. |
|
|
|
|
|
|
Latency alert not firing.