Time to truncate?

VMware specific discussions

Time to truncate?

Veeam Logoby millardjk » Thu Jan 14, 2016 4:46 am

Simple question: should I be investigating further if the (nightly incremental) backup of a SQL server (with 15min log backups) takes 1:30 and Veeam spends 1:18 of it at the "Truncating transaction logs" stage?
millardjk
Veeam Vanguard
 
Posts: 93
Liked: 18 times
Joined: Sun Dec 09, 2012 3:50 am
Full Name: Jim Millard

Re: Time to truncate?

Veeam Logoby PTide » Thu Jan 14, 2016 11:56 am

Hi,

I suggest you to open a case with our support team because it's hard to tell what's happening without logs investigation. The thing is that no SQL log truncation should occur during incremental run - all log operations have to be handled by a separate sub-job that runs (according to your settings) every 15 minutes.

Please don't forget to post your case ID in this topic.

Thank you.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

Re: Time to truncate?

Veeam Logoby millardjk » Wed Jan 20, 2016 5:30 pm

Support case: 01423731

Logs, events, etc are in the analyst's hands.
millardjk
Veeam Vanguard
 
Posts: 93
Liked: 18 times
Joined: Sun Dec 09, 2012 3:50 am
Full Name: Jim Millard

Re: Time to truncate?

Veeam Logoby millardjk » Mon Feb 01, 2016 12:41 am 1 person likes this post

Appears that "competition" between native backup/maintenance jobs and Veeam were the root cause. Removing the Veeam SQL truncation task (the DBA was pretty adamant about keeping the native tasks) cleaned up the issue.
millardjk
Veeam Vanguard
 
Posts: 93
Liked: 18 times
Joined: Sun Dec 09, 2012 3:50 am
Full Name: Jim Millard

Re: Time to truncate?

Veeam Logoby millardjk » Tue Feb 02, 2016 8:44 pm

And even after explicitly disabling log truncation in the guest interaction portion of the backup config, I'm still getting a) RPC timeout errors, b) long "log truncation" events, etc. This is driving me nuts.
millardjk
Veeam Vanguard
 
Posts: 93
Liked: 18 times
Joined: Sun Dec 09, 2012 3:50 am
Full Name: Jim Millard

Re: Time to truncate?

Veeam Logoby foggy » Sun Feb 07, 2016 6:55 pm

Jim, I can see your case is already closed, haven't you thought of re-opening it for further deeper investigation?
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 17 guests