I want to set up transactional replication of one table (not terribly huge) to ~80 other SQL Servers. I set up 10 systems first, this worked. Then I added the rest. All were set on 1/hour schedules. After about 30 minutes, the system was completely swamped. In performance monitor, both CPUs and the disk is at 100% usage.
I see three distrib.exe processes each consuming 2 GB of RAM! This is VM Size in the process monitor. Mem Usage is an order of magnitude lower (1-2 MB). Why would this happen?
After a while, the system runs out of RAM and other problems begin.