Kendal Van Dyke (3/30/2010)

---

David,

Can you elaborate on the following statement you made:

the number of records in the MSRepl_transactions table is likely to be very high and once it has gone beyond a certain size

and provide guidance on what that "certain size" is and how someone knows if they've exceeded it?

Also, do you have any suggestions for other steps that someone should take to optimize their existing distribution database before deciding that it's time to create a new one?

Kendal Van Dyke

@sqldba