Post reply

latency of suprresion of the disstribution base

  • January 31, 2018 at 6:11 am

    #335818

    Hello everyone
    I have transactionnel réplication That Works properly 
    the only problem it's time to clean up old transactions in the disstribution database  
    normally the job of deletion must not go beyond the 10 minute  now i take more than 30 minutes
    Is there a way to speed up the deletion process?
    thanks 

  • January 31, 2018 at 8:04 am

    #1978029

    joujousagem2006 1602 - Wednesday, January 31, 2018 6:11 AM

    Hello everyone
    I have transactionnel réplication That Works properly 
    the only problem it's time to clean up old transactions in the disstribution database  
    normally the job of deletion must not go beyond the 10 minute  now i take more than 30 minutes
    Is there a way to speed up the deletion process?
    thanks 

    There can be many reasons for the cleanup taking more time. It looks like the distriubtion cleanup job is running but you also want to make sure it is actually deleting records so check the job history for the distribution clean up. The details of the history will tell you how many rows deleted.
    Having immediate sync enabled can cause a growth in the distribution database which can slow down a lot of things. By default, the transactions will be deleted once the subscribers receive those transactions. Enabling immediate sync will allow transactions and snapshots to be maintained longer to support adding new subscribers. And that also works in conjunction with the retention periods. So all of those can have an impact and you would want to check the setting for immediate sync and the retention periods.
    There still can be many other things but I think those that I mentioned are likely some of the most common reasons. So you would want to check those first

    For more information on immediate sync and it's impact on the distribution clean up, refer to this article:
    What Immediate_sync means in Transactional Replication

    And this article will walk you through how to check and correct the issue if needed:
    HELP - My Distribution Database Is HUGE, But I Don't Have A Lot Of Commands In Queue

    In terms of retention periods, this article shows you how to check these for subscriptions and transactions - those are two separate settings:
    Troubleshooting Slow SQL Server Replication issue due to Distributor Database Growth

    Sue

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

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