How to resolve when Distribution Database is growing huge (+25gig)

Yes, I know, huge database is kind of relative, but generally if you see Distribution database growing more the 100gig it might indicate Distribution Cleanup processes is having a hard time deleting already delivered transactions.  In SQL Server 2017 you can customize the cleanup batch size via SQL Server Management Studio under the Distributor properties dialog, however, for…

3