Results 1 to 2 of 2
  1. #1
    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?

  2. #2
    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."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts