question

DM-0933 avatar image
0 Votes"
DM-0933 asked DM-0933 commented

Configuring internet outage/latency alert in transactional replication

It happens once in while that due to internet outage at publisher or subscriber; records don't sync at subscriber server; until internet resumes; please suggest at way to configure internet outage/latency alert in Sql Server OR in Windows OS that alert about it.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi DM-0933,

How are things going? Are the answers helpful?
Please feel free to let us know if you have any other question. If the post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered DM-0933 commented

I use this method:
https://www.mssqltips.com/sqlservertip/2258/monitor-sql-server-replication-latency-using-tracer-tokens/

Create a job which runs every 15 mins and sends an email alert on failure.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi TomPhillips-1744,

Thanks for your revert. Testing the solution with various threshold/latency limits. Thanks to AmeliaGu-msft too for her revert.

0 Votes 0 ·
AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi DM-0933,

You can try to create a table with a single row storing current date-time (updated via a SQL job every minute) in each publication, replicate that data to your subscriber and measure the difference between the current time and time-stamp in the subscriber table.
Please refer to the following articles which might be helpful:
Monitoring Transaction Replication Latency in Real Time
Monitoring SQL Server Transactional Replication

Best Regards,
Amelia


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.