Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VMware/NetApp Snapmirror transfer size question

Posted on 2012-03-14
4
Medium Priority
?
869 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 124
ID: 37721254
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
ID: 37738626
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 124

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 1500 total points
ID: 37738736
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
ID: 37738746
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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
Ransomware is a malware that is again in the list of security  concerns. Not only for companies, but also for Government security and  even at personal use. IT departments should be aware and have the right  knowledge to how to fight it.
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

972 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