Page 1 of 2

SQL restore speed

Veeam LogoPosted: Mon Mar 14, 2016 10:46 am
by Redline
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

Re: SQL restore speed

Veeam LogoPosted: Mon Mar 14, 2016 11:44 am
by foggy
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.

Re: SQL restore speed

Veeam LogoPosted: Mon Mar 14, 2016 1:03 pm
by Redline
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

Re: SQL restore speed

Veeam LogoPosted: Tue Mar 15, 2016 12:18 pm
by foggy
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?

Re: SQL restore speed

Veeam LogoPosted: Tue Mar 15, 2016 12:40 pm
by Redline
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?

Re: SQL restore speed

Veeam LogoPosted: Wed Mar 16, 2016 2:24 pm
by Gostev
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!

Re: SQL restore speed

Veeam LogoPosted: Fri Mar 18, 2016 5:42 am
by Redline
Hi, I've opened the case - #01734574

Re: SQL restore speed

Veeam LogoPosted: Tue Mar 29, 2016 8:08 am
by Redline
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

Re: SQL restore speed

Veeam LogoPosted: Tue Jul 26, 2016 9:58 am
by eshteinman
Are there any changes in this regard??
after the update 1 situation has not changed (((

Re: SQL restore speed

Veeam LogoPosted: Tue Jul 26, 2016 10:58 am
by foggy
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.

Re: SQL restore speed

Veeam LogoPosted: Mon Aug 08, 2016 8:58 am
by eshteinman
after apply Update 2 no changes, restore speed stay very slow((( I don't understand why so important bug not fix

Re: SQL restore speed

Veeam LogoPosted: Mon Aug 08, 2016 11:23 am
by yunales
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

Re: SQL restore speed

Veeam LogoPosted: Mon Aug 08, 2016 1:33 pm
by foggy
Have you tried to install Veeam B&R remote console on the target SQL Server itself, to allow local mount?

Re: SQL restore speed

Veeam LogoPosted: Mon Aug 08, 2016 4:45 pm
by Vitaliy S.
@Evgeny, @yunales, please open support cases for these issues, so that we could forward this issue to our dev team.

Re: SQL restore speed

Veeam LogoPosted: Tue Aug 09, 2016 7:58 am
by yunales
Hey Vitaly,

case is filed @01875015

regards