size of msrepl_commands

  • We do quite a bit of replication.  There are almost 41 million rows in our msrepl_commands table.  I'm new to replication, so this seems like an unreasonable number to me.  Is this a normal size?  If not, how can I go about eliminating some of the records?

    Thanks for any information.

  • Problem solved.  Distribution cleanup job was not running.   Recordcount is now less than 1000.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply