Replication – disturibution | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication – disturibution

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
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

Hi, are u using Anonymous Subscriptions ? What is the distribution retention period in u r setup? Madhu
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.
Thanks for reply.. emamuthu
emamuthu, Can please share your solution to your problem. Mohammed U.