Discussions specific to the VMware vSphere hypervisor
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 10, 2016 8:23 am

Please write in this topic answer from technical support

JoshuaPostSAMC
Expert
Posts: 124
Liked: 17 times
Joined: Jul 30, 2015 7:32 pm
Contact:

Re: SQL restore speed

Post by JoshuaPostSAMC » Aug 15, 2016 3:18 pm

We just ran into this same thing. Restored a 100 GB database on a VM in our UCS cluster with 10 GB networking and it took almost 3 hours to complete. I'm collecting details of how the restore was ran, but I expect it was from a remote console on the admin's workstation and trying to restore directly into the target SQL server. It really needs to be addressed so the restores can happen as fast as possible.

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 18, 2016 11:55 am

just a quick update. As requested by Vitaly I opened up a case with reference to this thread. But the case was not forwared to the Dev team. Instead I need to do some testing and upload the log bundle.

here's the answer from Roman Rakhimov:
I'm sorry to bother you.

My escalation engineer required more data to continue this case handling.


Can you please clarify, is restore with 'export' done locally or to the same target server?

Please provide us with following information:

1. Infrastructure description:
- Veeam B&R version and build number
- Backup job name used in SQL DB restore session
- Server name where console was executed for restore session
- SQL VM name
- Backup repository name where backup file is located (type of connection: NFS, iSCSI, CIFS, DAS)

2. Collect restore sessions logs:
* One bundle for 'restore to original' SQL server
* Second log bundle for 'export to another folder'
------------------------------------------------------------

I dont understand why I must test and log everything again since it's cleary a bug! But so be it....

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

Re: SQL restore speed

Post by Gostev » Aug 18, 2016 9:58 pm

9.5 will have SQL Server database restore performance improved in a few times.

arosas
Enthusiast
Posts: 26
Liked: 5 times
Joined: Jun 09, 2015 9:33 pm
Full Name: Tony Rosas
Contact:

Re: SQL restore speed

Post by arosas » Apr 12, 2017 2:44 pm

9.5 still has the same speed issue. Has this been addressed or is installing the console on the target SQL servers the only solution?

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

Re: SQL restore speed

Post by foggy » Apr 12, 2017 2:50 pm

Hi Tony, yes database restore performance was improved in v9.5 up to 3 times. If you're still seeing performance issues, I suggest contacting support for a closer look at your setup (reasons could be environmental).

arosas
Enthusiast
Posts: 26
Liked: 5 times
Joined: Jun 09, 2015 9:33 pm
Full Name: Tony Rosas
Contact:

Re: SQL restore speed

Post by arosas » Apr 24, 2017 4:59 pm 1 person likes this post

We have all SQL backups going to a certain repository. Support suggested changing the mount server setting for this repository to always be our SQL staging server instead of the Veeam server. When we did this the restore speed was tremendously better.

acoman
Lurker
Posts: 2
Liked: never
Joined: Sep 05, 2014 6:27 pm
Full Name: Adrian Coman
Contact:

Re: SQL restore speed

Post by acoman » Oct 17, 2017 1:41 pm

Hello,

I have the same problem with a SQL DB restore using the command shell of Veeam Explorer for Microsoft SQL Server, and thanks to veeam-backup-replication-f2/automate-re ... ml#p237865 who provided with a nice script that can be used either with Windows task scheduler, or just configured to run at the end of the backup job.
My problem is that to restore a 10GB DB from a Nimble Storage repository takes around 3 hours.....

Did someone find any solution to improve the restore speed?

I forgot to mention I use the lates version of Veeam B&R 9.5.0.1038, on which as per Gostev vmware-vsphere-f24/sql-restore-speed-t3 ... ml#p185375 the speed transfer has been improved.

Regards

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

Re: SQL restore speed

Post by foggy » Oct 18, 2017 11:39 am

Hi Adrian, I suggest you contacting support to verify whether your setup is optimal in terms of restore and identify the performance bottleneck. Btw, do you restore from a storage snapshot?

Post Reply

Who is online

Users browsing this forum: No registered users and 23 guests