SQL Server Performance

Finding the amount of data transfer for a mirroring server

Discussion in 'SQL Server 2005 Database Mirroring' started by contactjimmyus, Oct 18, 2010.

  1. HI,
    I have a sql 2005 box that needs to be mirrored .The server is configured to take transaction log backup and the file size comes to 2.5 gb to 3 gb and is scheduled once a day. How to calcullate the bandwidth required for this db to be mirrored between sites.Most of the transactions are happen at morning time ie uniform around 5 hours .
    If we calculate the log creation per minute it comes to 10 MB The calculation is {( 3*1024)/ (60*5) }
    So we need 10 mb /minute transfer rate .This is we calculate the bandwidth for the connection
    Thanks
  2. MohammedU New Member

    Are you planning to use database mirriring or log shipping?
    If you are planning to use mirroring, make sure you have the right edition of sql server.
    In SE, asynchronous mirroring is not available.
    Why do you take transaction log daily intead of every 15/30/60 minutes?

Share This Page