Solved

VMware/NetApp Snapmirror transfer size question

Posted on 2012-03-14
4
843 Views
Last Modified: 2012-06-21
We just stood up a new Virtual Infrastruture with a NetApp filer. We have a PROD and DR filer in place onsite. We have our snapmirror relationships setup and have started monitoring the traffic flow for these relationships to make sure we can handle the network load when the mirrors update every night. The plan is to move the DR filer offsite once this study is done.

We have a total of 36 VMs. 95% Windows 2008 R2. We place 10 VMs per datastore, with the exception of one datastore for the file server (different backup needs). Out of these servers, we have 2 SQL servers.1 small SQL server for a one off app, the other is the main SQL server, 10+ DBs, heavy I/O.


Between 5 datastores, we run one nightly backup via NetApp VSC. The total transfer size for all 5 datastores last night was 316GBs. This is a "normal" production day here meaning nothing was done out of the ordinary that would have infalted the deltas.

Does this sound "typical"?
0
Comment
Question by:MMRNLA
  • 2
  • 2
4 Comments
 
LVL 117

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
Once you have completed the first Snap Mirror, only the Snapshots should be "Snap Mirroring" to the DR site NetApp Filer.

The Delta in the Snapshots, will depend on the daily change in the VMs on the LUNs.

Do you know, by how much your VMs are changing on a daily basis?
0
 
LVL 1

Author Comment

by:MMRNLA
Comment Utility
Let me know if I am looking at this correctly.

My DBA just informed me of the following:

Every night SQL does a native backup. This backup job dumps the data locally. Saturday night's backup yielded 78GB's of data. NEXT it copies these files to another local drive with a 14 day retention on those files. During this process it also checks and deletes the oldest set of files. SO.. with this in mind, this is what i'm thinking happens. Please correct me if I am wrong.

SQL backup = 77GB
Copy of backup to another drive = 77GB
Removal of oldest backup = (guessing here) = 70GB

Total snapshot size for these changes = 322GB

Am I correct in thinking that when the job deletes the oldest backup that this translates into 70GBs of deltas ?
0
 
LVL 117

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
Comment Utility
That will be the issue, and we have seen this practice, because SQL dbas do not understand NetApp filer snapshots.

thats why your deltas are so large.

I would recommend the Backup to another non NetApp Source, or look at Snap Manager For SQL which is a very effecient method of leveraging SQL snapshots and NetApp filer storage, or you will have to deal with this legacy practice.
0
 
LVL 1

Author Comment

by:MMRNLA
Comment Utility
We are scheduled to deploy SnapManager for SQL here within 2 weeks.

Quick question, when you delete files, this translates into deltas correct? In other words, If I delete a 10GB file. The snapshot that night will pick this up as a 10GB delta correct?
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This is an issue that we can get adding / removing permissions in the vCSA 6.0. We can also have issues searching for users / groups in the AD (using your identify sources). This is how one of the ways to handle this issues and fix it.
This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
Teach the user how to convert virtaul disk file formats and how to rename virtual machine files on datastores. Open vSphere Web Client: Review VM disk settings: Migrate VM to new datastore with a thick provisioned (lazy zeroed) disk format: Rename a…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now