Post reply

Transactional replication latency issue

  • March 10, 2019 at 7:00 am

    #379963

    Hi,

    We configured Transactional replication. Suddenly in the replication monitor the current average performance it is showing as critical. I inserted tracer token .From publisher to distributor it is showing pending,distributor to subscriber showing as pending. total latency is as pending.

    The data is not replicating. what are the things i need to do to resolve the issue. Please guide.

    Thanks,
    Jo

  • March 10, 2019 at 11:03 pm

    #2024052

    Are you seeing any errors in Replication?

    USE [distribution]
    GO
    SELECT [time],[error_text]
    FROM MSrepl_errors
    WHERE CAST([error_text] AS VARCHAR(MAX)) <> '' AND [error_text] IS NOT NULL
    ORDER BY [time] DESC

    • This reply was modified 5 years, 7 months ago by  HandyD.
    • This reply was modified 5 years, 3 months ago by  Dave Convery.

Viewing 2 posts - 1 through 1 (of 1 total)

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