I have inherited an environment where Merge replication is used to replicate the whole database to another server on the same site. One DB is used for the inhouse system and the replicated one used for a web application. Both are using the same tables.
They say it is used for both load balancing and a HA solution. Has anyone else come across something like this? I know Merge replication is not designed for this, but are there ANY benefits in this setup. Wont the load balancing reasoning be counter productive because of the addition workload of the triggers and replication?
Any advise on this will help, as I want to make a proposal to management
Thanks..