02-19-12, 15:27 #1Registered User
- Join Date
- Feb 2012
Unanswered: Large Distribution Database with Few RowCount
I have a distribution database that has grown over 50g. Distribution cleanup takes over 15 hours to run and there are always very few rows in msrepl_Commands. Usually only a few hundred. Everything is being replicated fine, but I fear a storm coming. Anyone know why distribution would be so large with so few rows? Also, Ghost Cleanup has been running all week, so I'm thinking maybe the records marked for deletion aren't being deleted?
02-22-12, 12:51 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
msrepl_commands, if I remember correctly, does not contain the actual data, but, as the name implies - the commands to modify the data. And for a large volume of data to be modified all you need is a one crazy update.
The point is not in how many rows are in msrepl_commands. Did you check the recovery model of the database? Should be simple, if not - switch to simple."The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."