SQL Server Performance Forum – Threads Archive
Third Party replicationI am looking to see how I can best split up a server. I have one server with a SQL Server database. I want to take the load off the one server and "replicate" the entire database to a second server. The second server will be used primarily for reports and special query’s. The other server will be used for new orders (Order Entry system). If I split the workload between two servers…I am hoping to reduce the bottleneck problems. Is there a third party software program that can replicate data between the two servers? Sort of like syncing the data all the time? Thanks for any help.
Why use third party software? why not just the built-in sql replication or log shipping? Cheers