1

I am tasked with setting up a disaster recovery for one of our system. The primary server is in FL and the secondary is in Germany. The application is a global application within my company.

I am not sure if I should use Log shipping or Mirroring. What I have read is that mirroring will have an adverse effect on the performance of my application. Is this true? Does this mean that any time a user modify or save a record that it will take longer to get a positive response.

Thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
premtemp
  • 11
  • 2

3 Answers3

1

Mirroring can have different performance impacts depending on the operating mode you choose. If you are mirroring you can have three operating modes: High Protection (with and without automatic failover) and High Performance.

Basically, these amount to synchronous and asynchronous mirroring. With High Protection your application will be waiting for the mirroring to finish before considering the transaction complete. In High Performance mode your application will not wait for the mirroring to have been committed. In fact, it is not guaranteed at any point in time that all the most recent transactions will have been saved in the mirror's transaction log.

One of the main factors to consider with mirroring will be the round trip time of your network. Higher latency will impact more heavily on your performance. You will need to weigh the performance cost against your specific recovery (and failover) requirements.

If you haven't already, you should read Database Mirroring in SQL Server 2005 and Database Mirroring Best Practices and Performance Considerations.

Randy Levy
  • 22,566
  • 4
  • 68
  • 94
0

Mirroring would keep both the primary and DR environments in synch 100% of the time and thus eliminate the possibility for data loss. However, as you noted, this has an adverse affect on performance, but may be necessary in situations that cannot tolerate any data loss (ex. financial applications). Shipping logs and applying them to the standby database at the DR site doesn't have the same impact on user response time, but opens up a small period during which data loss could potentially occur.

btreat
  • 1,554
  • 8
  • 10
0

Mirroring is operate synchronously (wait until the log is committed to DB), usually deploy on good network connection (LAN)

Log shipping is operate asynchronously (will not wait the log is committed to DB), usually deploy over MPLS / VPN or slow network

so for your objective, u should use Log Shipping

user1172579
  • 575
  • 1
  • 7
  • 22