Snapshot removal issues of a large VM

VMware specific discussions

Re: Snapshot removal issues of a large VM

Veeam Logoby unsichtbarre » Mon Jun 22, 2015 1:57 pm

We are running ESXi Build 2638301.

Also, our storage is 10Gb iSCSI, both sides, but dis-similar brands and not 3PAR, so no storage snapshots as far as I know
unsichtbarre
Enthusiast
 
Posts: 65
Liked: 16 times
Joined: Mon Mar 08, 2010 4:05 pm
Full Name: John Borhek

Re: Snapshot removal issues of a large VM

Veeam Logoby foggy » Mon Jun 22, 2015 2:01 pm

Storage snapshots are also supported on StoreVirtual and some NetApp models. You do not need similar storage on the target side.
foggy
Veeam Software
 
Posts: 15272
Liked: 1131 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

[MERGED] : New to B&R - Setup Advice Needed

Veeam Logoby cardendave » Wed Jul 22, 2015 8:02 am

Hi Guys

I am new to Backup & Replication, we are an MSP and are trialling this on a number of clients. Seems to be a great product but I have had 2 occasions where 9am has struck and vmware is still removing a snapshot making the server inaccessible? What are the considerations that should be made to avoid this?

Thanks

Dave
cardendave
Service Provider
 
Posts: 27
Liked: 1 time
Joined: Wed Jul 22, 2015 7:59 am
Full Name: Dave King

Re: Snapshot removal issues of a large VM

Veeam Logoby v.Eremin » Wed Jul 22, 2015 8:16 am

Hi, Daven,

Your post has been merged into the existing discussion; some recommendations can be found in this rather long thread.

Thanks.
v.Eremin
Veeam Software
 
Posts: 13701
Liked: 1020 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

[MERGED] JDE ERP system failing during vmware snapshot conso

Veeam Logoby egraeber » Thu Nov 12, 2015 4:01 am

I am having an issue with my JDE ERP system failing during snapshot consolidation at the end of the backup due to loss of connection with my SQL database. The database is MS SQL 2008 R2. The system is MS Windows 2008 R2 hosted on VMware ESXi 5.1. It is a very busy SQL server with a lot of data--around 10TB all together. The snapshot took around 2.5 hours to consolidate, however the issue didn't occur until the very end of the job which presumably corresponds to the time at which the final stun occurred. It doesn't seem that the stun was overly long and all of the databases are on an SSD array so I don't believe performance is an issue. Overall performance is excellent within my VMware environment, especially since we migrated the database onto the SSD array.

Two questions:
1. Is anyone else out there successfully backing up a large highly active SQL server dataset like this without incurring disconnects?
2. Is anyone else out there backing up a JDE database? If yes, have you faced or are you facing similar issues?

-- Eric
egraeber
Novice
 
Posts: 3
Liked: never
Joined: Thu Nov 12, 2015 3:35 am
Full Name: Eric Graeber

Re: JDE ERP system failing during vmware snapshot consolidat

Veeam Logoby PTide » Thu Nov 12, 2015 9:35 am

Hi,

Do you backup the whole server every time or just transaction logs? Also what's your transport mode?

Thank you.
PTide
Veeam Software
 
Posts: 3230
Liked: 269 times
Joined: Tue May 19, 2015 1:46 pm

Re: Snapshot removal issues of a large VM

Veeam Logoby egraeber » Thu Nov 12, 2015 4:05 pm

So far I have only executed one full backup. Once it crashed the application I had to back off until I can identify the problem. I'm not sure what you mean by "transport mode". Please elaborate.
egraeber
Novice
 
Posts: 3
Liked: never
Joined: Thu Nov 12, 2015 3:35 am
Full Name: Eric Graeber

Re: Snapshot removal issues of a large VM

Veeam Logoby PTide » Thu Nov 12, 2015 4:17 pm

Your topic has been merged to an existing thread, please review possible solutions provided and check whether any of them applicable to your environment. The first step would be to offload the storage your SQL server resides at.

I'm not sure what you mean by "transport mode".
Please take a look at the article and check if you can use another transport mode to optimize your backup process. If any questions arise feel free to ask.

Also please note, that you don't have to take a whole VM snapshot every time. Instead you can utilize transaction log processing feature in order to meet your SQL server RPO.

Thank you.
PTide
Veeam Software
 
Posts: 3230
Liked: 269 times
Joined: Tue May 19, 2015 1:46 pm

Re: Snapshot removal issues of a large VM

Veeam Logoby egraeber » Thu Nov 12, 2015 11:29 pm

Transport mode is automatic. The SQL server and VEEAM server are both VM's in the same VMware cluster. The VMware cluster consists of 5 Cisco UCS blades with PureStorage SSD array on 8Gig Fiber Channel interconnect. The hotadd process seems to be working exactly as expected for the backup proxy (the VEEAM server itself) and throughput is pretty good--243.1MB/s. My backend is a SATA based array which also has 8Gig FC connection.

Our SQL maintenance plans make daily full backups and TRN's on the half hour which we are using for log shipping to our DR system. I have turned off log file processing in order to avoid interfering with this process. Either way, it is my understanding that this is more of a "convenience feature" so that Veeam can manage the logfile truncation without involving a DBA. It is my understanding that this isn't relevant to the size of the VIB's that are created or the method of their creation.
egraeber
Novice
 
Posts: 3
Liked: never
Joined: Thu Nov 12, 2015 3:35 am
Full Name: Eric Graeber

Re: Snapshot removal issues of a large VM

Veeam Logoby PTide » Fri Nov 13, 2015 9:35 am

Ok, first you need to get your full backup done. Have you checked this article already? There mentioned couple of things to check, so if you haven't done that yet please follow the link.

PureStorage SSD array on 8Gig Fiber Channel interconnect<...>
You've mentioned FC - you might want to use direct SAN mode - it's even faster than hotadd. You'll need a dedicated physical proxy that has a direct access to your production via FC or iSCSI, however.
PTide
Veeam Software
 
Posts: 3230
Liked: 269 times
Joined: Tue May 19, 2015 1:46 pm

[MERGED] Application Error

Veeam Logoby tourdemon » Thu Feb 04, 2016 2:31 pm

Hello all< i have a Tax application server that I want to back up hourly, it is not a database server, just a server that stores Tax files in folders on drives that are mapped for users which the application accesses. Anyway, when I performed the first hourly backup today it disconnected the users for a brief second. I have app aware and guest file indexing enabled. I am wondering if I need app aware enabled here and if this is what caused the users to be disconnected. Your help would be greatly appreciated.
tourdemon
Influencer
 
Posts: 10
Liked: never
Joined: Mon Dec 05, 2011 1:06 pm
Full Name: Joe Rubino

Re: Application Error

Veeam Logoby foggy » Thu Feb 04, 2016 2:42 pm

Joe, please check whether disconnection occurred at the time VM snapshot was committed after the backup.
foggy
Veeam Software
 
Posts: 15272
Liked: 1131 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Application Error

Veeam Logoby tourdemon » Thu Feb 04, 2016 2:48 pm

Yes, around the time the disks consolidated and the snapshot was removed.
tourdemon
Influencer
 
Posts: 10
Liked: never
Joined: Mon Dec 05, 2011 1:06 pm
Full Name: Joe Rubino

Re: Snapshot removal issues of a large VM

Veeam Logoby foggy » Thu Feb 04, 2016 2:59 pm

Then short stun is expected. Please review this thread for some hints allowing to eliminate this effect.
foggy
Veeam Software
 
Posts: 15272
Liked: 1131 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Snapshot removal issues of a large VM

Veeam Logoby tourdemon » Thu Feb 04, 2016 3:15 pm

Odd, when I was using Acronis, this didn't happen and it was backing up every 15 minutes. If I change to every 15 instead of an hour wouldn't that make the snapshot smaller, therefore maybe eliminating the short stun? I can not have users constantly being kicked out and having to re-login to the application, talking about 65 accountants.
tourdemon
Influencer
 
Posts: 10
Liked: never
Joined: Mon Dec 05, 2011 1:06 pm
Full Name: Joe Rubino

PreviousNext

Return to VMware vSphere



Who is online

Users browsing this forum: Yahoo [Bot] and 3 guests