SQL restore speed

VMware specific discussions

SQL restore speed

Veeam Logoby Redline » Mon Mar 14, 2016 10:46 am

I have a problem with restore speed on my v9 installation. If I try to restore using restore wizard -> Application items -> SQL server and restore to some SQL server I get about 85 Megabit/sec speed over my 1Gb/s link. But if I choose Extort database and put it on a shared folder of that same SQL server I get 900 Megabit/sec. Simple copy using windows explorer from Veeam server to SQL also shows good speeds around 900 Megabits/s.

One thing I noticed is in SQL item-level restore scenario it mounts backup to the target server c:\VeeamFLR folder and then copies it to the destination folder on the same server (and getting bad network speed). As I understand at this point no SQL activity is involved, just basic file copy? So what could be the problem?

Image
Redline
Novice
 
Posts: 5
Liked: never
Joined: Thu Nov 12, 2015 5:13 am

Re: SQL restore speed

Veeam Logoby foggy » Mon Mar 14, 2016 11:44 am

Could you please describe your setup in a bit more detail - where Veeam B&R is itself installed, what kind of repository is involved? Also, what restore options exactly are used in both cases? Thanks.
foggy
Veeam Software
 
Posts: 14752
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL restore speed

Veeam Logoby Redline » Mon Mar 14, 2016 1:03 pm

My test lab has vcenter server and a couple of HP DL360 G7 and Gen8 hosts. Veeam B&R is installed in Win 2012 R2 VM on one of the hosts, SQL is Win 2008 R2 VM on another host. All hosts are physically in the same location and connected via Cisco 3750 switch.

As for backup repository - I have HP P2000 (FC) with 12 2TB NL-SAS drives in Raid-6, it has a LUN presented to all hosts and formatted as VMFS datastore.

For restore in first case I open Restore -> Application Items -> Microsoft SQL server -> choose a full backup and get to the SQL Explorer. There I choose one of the DB's, Database restore -> Restore to another server -> restore to the selected image-level backup point -> enter SQL server domain name and necessary login/pass -> choose folder on destination server. In this case I see network speed jumping all over the place 70-80-100 Mb/s but no more than 150 anyway.

Second time I open Restore -> Application Items -> Microsoft SQL server -> choose a full backup and get to the SQL Explorer. There I choose one of the DB's, Export -> Export to another folder -> restore to the selected image-level backup point -> choose the same shared folder as in the first case on destination server. Here I see network speed steady at 900-910 Mb/s
Redline
Novice
 
Posts: 5
Liked: never
Joined: Thu Nov 12, 2015 5:13 am

Re: SQL restore speed

Veeam Logoby foggy » Tue Mar 15, 2016 12:18 pm

In the first case, the backup is indeed mounted to remote server, while in the second it is mounted locally and file is copied over the network (similar to your "Simple copy using windows explorer" test).

What Veeam B&R version do you use?
foggy
Veeam Software
 
Posts: 14752
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL restore speed

Veeam Logoby Redline » Tue Mar 15, 2016 12:40 pm

Yes, I understand this, but what can be the reason for such a difference in the speed? I use v9.0.0.902 for this test.

On a side note, I've noticed in the similar test on v8 it is mounting backup to the local server no matter if I choose SQL item-level recovery or Export. This is a screenshot of my recovery from v8 (Restore -> Application Items -> Microsoft SQL server -> choose a full backup and get to the SQL Explorer. Choose DB, Database restore -> Restore to another server -> restore to the selected image-level backup point -> enter SQL server domain name and necessary login/pass -> choose folder on destination server.) And the speed is high in this case too
Image

Maybe as a workaround there is a way to force it to mount the backup locally in v9?
Redline
Novice
 
Posts: 5
Liked: never
Joined: Thu Nov 12, 2015 5:13 am

Re: SQL restore speed

Veeam Logoby Gostev » Wed Mar 16, 2016 2:24 pm

I've talked to the devs and they are quite puzzled, and would like to investigate this further, possibly via webex. If you are available, please open a support case and let me know the case ID. Thanks!
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: SQL restore speed

Veeam Logoby Redline » Fri Mar 18, 2016 5:42 am

Hi, I've opened the case - #01734574
Redline
Novice
 
Posts: 5
Liked: never
Joined: Thu Nov 12, 2015 5:13 am

Re: SQL restore speed

Veeam Logoby Redline » Tue Mar 29, 2016 8:08 am

I got the answer from support - as I understand the low speed in SQL restore operations is due to the fact that v9 is mounting backup to the target server to perform necessary operations (as opposed to v8 which mounts to the veeam server itself). And this new way of work was not yet properly optimized, so for now if you want to get full speed in SQL restore you should either use the Export option or start the restore from the Veeam Remote Console installed on the SQL server
Redline
Novice
 
Posts: 5
Liked: never
Joined: Thu Nov 12, 2015 5:13 am

Re: SQL restore speed

Veeam Logoby eshteinman » Tue Jul 26, 2016 9:58 am

Are there any changes in this regard??
after the update 1 situation has not changed (((
eshteinman
Novice
 
Posts: 4
Liked: 2 times
Joined: Tue Dec 09, 2014 10:54 am
Full Name: Evgeny Shteynman

Re: SQL restore speed

Veeam Logoby foggy » Tue Jul 26, 2016 10:58 am

No changes, as far as I know. I recommend you contacting support to confirm the issue and also for tracking purposes, since the most often reported issues get fixed first.
foggy
Veeam Software
 
Posts: 14752
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL restore speed

Veeam Logoby eshteinman » Mon Aug 08, 2016 8:58 am

after apply Update 2 no changes, restore speed stay very slow((( I don't understand why so important bug not fix
eshteinman
Novice
 
Posts: 4
Liked: 2 times
Joined: Tue Dec 09, 2014 10:54 am
Full Name: Evgeny Shteynman

Re: SQL restore speed

Veeam Logoby yunales » Mon Aug 08, 2016 11:23 am

Hello guys,

this thread got me curious so I tested the same with an environment of one of our customers.
And I can reproduce exactly the same issues with restore speed as the thread starter!

While using the " SQL restore to another servers" yields around 100-140 MBIT/s which is like 12-17 MB/s , the "export to another folder" get around 700-800 MBIT which is acceptable.

So please forward this issue to R&D this is a major falw. What good is a ultra fast backup of a 2 TB Database, when the restore takes 2 days to complete??

regards
yunales
Influencer
 
Posts: 14
Liked: 4 times
Joined: Wed Aug 20, 2014 7:34 pm
Full Name: P K

Re: SQL restore speed

Veeam Logoby foggy » Mon Aug 08, 2016 1:33 pm

Have you tried to install Veeam B&R remote console on the target SQL Server itself, to allow local mount?
foggy
Veeam Software
 
Posts: 14752
Liked: 1083 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL restore speed

Veeam Logoby Vitaliy S. » Mon Aug 08, 2016 4:45 pm

@Evgeny, @yunales, please open support cases for these issues, so that we could forward this issue to our dev team.
Vitaliy S.
Veeam Software
 
Posts: 19570
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL restore speed

Veeam Logoby yunales » Tue Aug 09, 2016 7:58 am 2 people like this post

Hey Vitaly,

case is filed @01875015

regards
yunales
Influencer
 
Posts: 14
Liked: 4 times
Joined: Wed Aug 20, 2014 7:34 pm
Full Name: P K

Next

Return to VMware vSphere



Who is online

Users browsing this forum: alanbolte, Google [Bot] and 12 guests