• It is a Transactional replication.

    The no replicated commands is at the Distributor only.

    I can see the log reader sending commands frequently to the Distributor. The distributor is growing fast.

    I made a backup earlier of the distributor to truncate the log at the publisher.

    The log_reader keeps blocking the cleaning jobs and my replication monitor screen as well.

    There is a big job running at the publisher with a 50GB of transact log.

    Below is extract of the results:

    Log Reader

    comments:2 transaction(s) with 2 command(s) were delivered.

    delivery_time:8655091

    delivered_transactions:3332865

    delivered_commands:10141021

    average_commands:3

    delivery_rate: 1171

    delivery_latency: 0

    Distributor agent

    comments:No replicated transactions are available.

    delivery_time:0

    delivered_transactions:0

    delivered_commands:0

    average_commands:0

    delivery_rate:0

    delivery_latency:0

    error_id:0

    job_id:0x59BFF67CF73193449AD40A4D58556FAB

    local_job:1

    profile_id:4

    agent_id:1

    last_timestamp: 0x00000000002A6D19