Discussions specific to the VMware vSphere hypervisor
Redline
Novice
Posts: 5
Liked: never
Joined: Nov 12, 2015 5:13 am
Contact:

SQL restore speed

Post by Redline » 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

foggy
Veeam Software
Posts: 16841
Liked: 1361 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL restore speed

Post by foggy » 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.

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

Re: SQL restore speed

Post by Redline » 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

foggy
Veeam Software
Posts: 16841
Liked: 1361 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL restore speed

Post by foggy » 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?

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

Re: SQL restore speed

Post by Redline » 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?

Gostev
Veeam Software
Posts: 23001
Liked: 2890 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL restore speed

Post by Gostev » 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!

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

Re: SQL restore speed

Post by Redline » Mar 18, 2016 5:42 am

Hi, I've opened the case - #01734574

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

Re: SQL restore speed

Post by Redline » 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

eshteinman
Novice
Posts: 4
Liked: 2 times
Joined: Dec 09, 2014 10:54 am
Full Name: Evgeny Shteynman
Contact:

Re: SQL restore speed

Post by eshteinman » Jul 26, 2016 9:58 am

Are there any changes in this regard??
after the update 1 situation has not changed (((

foggy
Veeam Software
Posts: 16841
Liked: 1361 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL restore speed

Post by foggy » 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.

eshteinman
Novice
Posts: 4
Liked: 2 times
Joined: Dec 09, 2014 10:54 am
Full Name: Evgeny Shteynman
Contact:

Re: SQL restore speed

Post by eshteinman » 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

yunales
Influencer
Posts: 15
Liked: 4 times
Joined: Aug 20, 2014 7:34 pm
Full Name: P K
Contact:

Re: SQL restore speed

Post by yunales » 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

foggy
Veeam Software
Posts: 16841
Liked: 1361 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL restore speed

Post by foggy » 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?

Vitaliy S.
Veeam Software
Posts: 21547
Liked: 1285 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL restore speed

Post by Vitaliy S. » 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.

yunales
Influencer
Posts: 15
Liked: 4 times
Joined: Aug 20, 2014 7:34 pm
Full Name: P K
Contact:

Re: SQL restore speed

Post by yunales » Aug 09, 2016 7:58 am 2 people like this post

Hey Vitaly,

case is filed @01875015

regards

Post Reply

Who is online

Users browsing this forum: No registered users and 26 guests