?
Solved

SAN replication : WAN bandwidth sizing & comparison to MS SQL mirroring

Posted on 2012-03-19
4
Medium Priority
?
735 Views
Last Modified: 2012-03-30
I have a need to mirror a Production MS SQL DB to a remote hot site.

Q1:
Would SAN replication be more efficient (ie requires less bandwidth
& less manual intervention in the event disaster strikes the Production
site) than MS SQL 2008 mirroring ?

Q2:
Currently we have MS SQL log shipping with the SQL log ship files being
sent over a 50Mbps WAN at regular intervals to DR site (I suppose this
is to update the DR database as I'm new to this project).  Can I base
the bandwidth required by taking the largest log ship file ever created
divided by the interval that the log ship file is being created?
Can this method of sizing the WAN bandwidth be used for both
SAN replication as well as MS SQL mirroring solutions?
0
Comment
Question by:sunhux
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 1060 total points
ID: 37738874
"I have a need to mirror a Production MS SQL DB to a remote hot site."


In my opinion SAN replication will not work in your case and your best option would be: "Database Mirroring"  high-performance mode (runs asynchronously) OR high-safety mode (synchronous)

http://msdn.microsoft.com/en-us/library/ms189852.aspx
0
 
LVL 40

Accepted Solution

by:
lcohan earned 1060 total points
ID: 37738963
Please see "SAN-over-WAN Applications Assessment" from link below to help you answer the two questions above. It is an older article but principles still stand today and as a side note my above answer is based on failure from our data center, SAN vendors(s) to ACTUALLY make it work not just as described by product(s) features - all recovery tests failed on the "replicated" SAN snapshots therefore we dropped it and (still) rely on old good SQL method including log shipping you currently have in place. Its all about how much data you can afford to loose and that dictates your log shipping or mirroring scenario. You could choose high safety if you can't afford any data loss and its working perfectly (for me on SQL 2005 and 2008 since 2010) including periodic disaster/recovery testing.

http://www.qlogic.com/Resources/Documents/WhitePapers/Routers/SN0130937-00.pdf
0
 
LVL 9

Assisted Solution

by:Shani Basha
Shani Basha earned 440 total points
ID: 37741495
In my opinion you can have SAN replication with compression and deduplication which saves WAN bandwidth

Recently lot of Enterprise storages and FC switches available in the market which supports these features

http://www.hds.com/groups/public/documents/webasset/hitachi-replication-solution.html?M=data-replication-solutions-cal
0
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 500 total points
ID: 37744921
Q1/No.  Since SQL 2008 database mirroring is fully compressed, it actually works better than SAN replication since it guarantees better transactional coherence between the databases.  SAN has no clue of transactional coherence.
Q2/No.  Log shipping is file based while mirroring is stream based.  Mirroring is more comparable to replication.  Plus mirroring is compressed.
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
When speed and performance are vital to revenue, companies must have complete confidence in their cloud environment.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question