I have setup transactional replication at a customer site with SQL 2008 R1 SP1 Enterprise Edition residing on Windows 2008 R2 Enterprise Edition x64. The replication is configured with one publisher, distributor (on the same engine as Publisher), and subscriber.
Replication is going okay and latency is excellent. And, undistributed commands grows to some amount and returns to zero with estimated time to apply at 0 seconds.
Also, note, I fixed a known bug with SP for distribution cleanup so that the proper amount of commands and transactions are being retrieved for deletion.
However, I noticed that the the number of commands and transactions keeps growing in the distribution database. Currently I show 6,388,422 records in the transactions table and growing and 32,998,193 records in the commands table and growing. The Distributor is configured as default with min and max retention period is 0 & 72, respectively with history at 48.
What I want to know is there a technique, calculations, or guideline to configure the distributor properties? I have Google'd but, what I find is where to configure these values. I am looking on how to change the values in a proper way to tune the distributor.