Compress Status Messages on Remote MP instead of using MP Replica
I run a single Primary Site Server supporting 26K clients. I also have two Regional MP's (Not MP Replicas).
The stat.box and statemsg.box files regularly fill up with over 20K+ files (supporting only a few thousand clients each) and it takes nearly 10 hours for the MP to send all those files (one by one) to the Site Server over the WAN.
The bandwidth utilization is minimal (stat.box with 27K files is only about 7MB in size) however sending that many individual files over the WAN is extremely inefficient.
Compressing these files into a single zip/cab/etc. before sending to the Site Server would drastically reduce the overall time to copy them and they could easily be decompressed/despooled on the Site Server and processed into the database.
For an infrastructure my size, this would greatly improve efficiency of the MP without the need to host a SQL Replica.