December 14, 2010 at 9:33 am
i seem to be getting lot of blocking in my distribution database caused by EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72 can anyone offer any insight into why this is happening ? I am doing transaction replication with 4 different publishers
December 14, 2010 at 9:54 am
When you establish a distributor it automatically creates a distribution clean up job on the distributor to remove old data from the distribution database. That job is your friend. 🙂
When that runs it can be slightly expensive and will cause blocking at times. There are some tuning suggestions if you search the web but I have found that if you limit the run times to "off hours" or lower activity hours you can get it to work with a lot less impact. So, change the job schedule.
Let me know if that is not an option.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply