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
emamuthu

---

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/

---

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.

---

]]>