SQL Server Performance

Third Party replication

Discussion in 'Performance Tuning for SQL Server Replication' started by gt420hp, Mar 5, 2006.

  1. gt420hp New Member

    I 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.
  2. Twan New Member

    Why use third party software? why not just the built-in sql replication or log shipping?

    Cheers
    Twan

Share This Page