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.

    Thanks
    emamuthu

    emamuthu, Dec 29, 2006
    #2

  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
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
    dineshasanka, Dec 31, 2006
    #2

  3. madhuottapalam New Member

    Hi,

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

    Madhu
    madhuottapalam, Jan 1, 2007
    #2

  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.
    MohammedU, Jan 1, 2007
    #2

  5. emamuthu New Member

    Thanks for reply..

    emamuthu
    emamuthu, Jan 3, 2007
    #2

  6. MohammedU New Member

    emamuthu,

    Can please share your solution to your problem.

    Mohammed U.
    MohammedU, Jan 3, 2007
    #2

Share This Page