Availability for the Always-On Enterprise
Post Reply
dbr
Enthusiast
Posts: 46
Liked: 1 time
Joined: Apr 06, 2017 9:48 am
Full Name: Daniel Brase
Contact:

Problem with management traffic SQL log backup

Post by dbr » Aug 14, 2017 7:33 am

Dear Dev Team,

We back up multiple SQL server with SQL log backup at various remote sites. These sites are connected with a low-bandwidth wan link (such as 5Mbit) to the main site where the Veeam B&R Server is running. Actually, we don't need more bandwidth because the users in these sites mainly work with Citrix and for that purpose the link is sufficient. I opened a case (#02267597) because the SQL log backup uses the wan link to capacity every 15 minutes (approximately 40MB per backed up vm). Since this data isn't backup data between the data movers it isn't possible to be throttled via network throttling rules. Could you please consider to add a possibility to throttle management traffic as well or check whether the amount of data being sent in every 15-minutes-cycle for every backed up vm is really necessary or can be reduced to a minimum?

Daniel

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

Re: Problem with management traffic SQL log backup

Post by foggy » Aug 23, 2017 2:33 pm

Hi Daniel, my first guess is that log shipping server is being involved in the process. Can you confirm or deny that?

dbr
Enthusiast
Posts: 46
Liked: 1 time
Joined: Apr 06, 2017 9:48 am
Full Name: Daniel Brase
Contact:

Re: Problem with management traffic SQL log backup

Post by dbr » Aug 24, 2017 12:42 pm

Hi foggy,

thanks for your reply. A direct connection is available between SQL vm and repository server and therefore no log shipping server is necessary (according to your help center link). Even if I select guest interaction proxy and log shipping server in remote site the amount of data being sent between proxy/repository server (a two in one vm in remote site) and Veeam B&R server remains the same. In one example the data is sent from veeam server port 50988 to proxy/repository server in remote site port 6160. Our network monitor tool shows 198MB of traffic between these ports every 15 minutes (default SQL log backup interval). According to help center port 6160 is use by Veeam installer service.

Remark: I'm on holiday the next three weeks. I will answer any replys once I'm back in office.

Daniel

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

Re: Problem with management traffic SQL log backup

Post by foggy » Aug 25, 2017 12:37 pm

Typically, there should not be such amount of traffic in the described configuration (where guest VM, repository and guest interaction proxy are in remote site, Veeam B&R in local site). Is it VMware or Hyper-V setup? Could you please check the size of transaction log backups metadata file in your repository (.VSM)?

dbr
Enthusiast
Posts: 46
Liked: 1 time
Joined: Apr 06, 2017 9:48 am
Full Name: Daniel Brase
Contact:

Re: Problem with management traffic SQL log backup

Post by dbr » Sep 19, 2017 9:53 am

We have a VMware only environment. The .vsm file has a size of 62MB.

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

Re: Problem with management traffic SQL log backup

Post by foggy » Sep 20, 2017 3:37 pm

I've checked the case and uploaded logs are not enough for investigation. Could you please collect the following:

- logs from Veeam B&R server: backup service logs, job logs and guest interaction proxy logs; server name/IP;
- logs from guest interaction proxy/repository server;
- logs from SQL Server VM, server name/IP.

You can ask your engineer for assistance in logs collection, upload the logs and ask for the case escalation.

Thanks.

dbr
Enthusiast
Posts: 46
Liked: 1 time
Joined: Apr 06, 2017 9:48 am
Full Name: Daniel Brase
Contact:

Re: Problem with management traffic SQL log backup

Post by dbr » Sep 28, 2017 4:21 pm 1 person likes this post

Unfortunately, I had to disable SQL log backup for the site that was mentioned in the case because we cannot do quality of service at the moment. Fortunately we have other sites with SQL log backup, too. But they run wan connections with qos. Anyway the amount of data should be similar, so I collected log information from another site.

Did you notice the file capture_edited.txt / capture.pcapng on the old case ftp share? That was a capture of data within one 15 minutes sql log backup cycle. Please have a look at the files. In addition I uploaded a new capture and a prepared capture along with logs of the corresponding job to the new ftp folder. Additionally I informed my support engineer and he will escalate the case.

You can find servernames and ips in the case.

New case: 02326051

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

Re: Problem with management traffic SQL log backup

Post by foggy » Sep 29, 2017 3:37 pm

Thanks, I've also let our QA engineers know about the update.

Post Reply

Who is online

Users browsing this forum: No registered users and 25 guests