Our current database is using merge replication (with P2P). We have several tables that are heavily used on both servers and were considering data partitions that would keep data partitioned by the site/server it originated from. I am wondering if anyone has done data partitions on a replicated (P2P/Merge) sql server database and:
Whether this offered benefits that outweighed the administrative costs.
What issues, if any, popped up as a result.