• On one particular publication we changed the retention period to 3 hours because if something goes wrong with the subscriber then the transactions start building up in the distributor and if that comes under stress the publisher log files start to bloat until disk space on the production box is threatened.

    It's worth mentioning that we do have to DBCC DBREINDEX or ALTER INDEX REBUILD regularly.

    The distribution databases are counted as system databases but they behave like user databases.