SQL Server Performance

Replication - disturibution

Discussion in 'SQL Server 2005 Replication' started by emamuthu, Dec 29, 2006.

  1. emamuthu New Member

    I have a question on Distribution database.

    There are couple of tables MSrepl_commands(more than 20 millon rows) and Msrepl_transactions(more than 5 millions rows) keeps on growing. I thought after applying the data to subcriber db, these data will be purged.

    My publisher and Sub are seems to be in sync.

    How do i troubleshoot it.


  2. dineshasanka Moderator

    The MSrepl_commands table contains rows of replicated commands.
    The MSrepl_transactions table contains one row for each replicated transaction

    so the data will not be deleted

    Contributing Editor, Writer & Forums Moderator

    Visit my Blog at
  3. madhuottapalam New Member


    are u using Anonymous Subscriptions ? What is the distribution retention period in u r setup?

  4. MohammedU New Member

    May your distribution cleanup is blocked could be dead lock victim...
    I think you can use sp_MSdistribution_cleanup procedure...
    Run the following command, it will all replicated transactions but not non replicated onece...
    What is the retention, it configured?

    EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 0

    Mohammed U.
  5. emamuthu New Member

    Thanks for reply..

  6. MohammedU New Member


    Can please share your solution to your problem.

    Mohammed U.

Share This Page