Comprehensive data protection for all workloads
Post Reply
fcoa
Novice
Posts: 8
Liked: never
Joined: Aug 09, 2016 8:55 pm
Full Name: Eric
Contact:

SQL Transaction Retreival Slow (Failing?)

Post by fcoa » Aug 25, 2016 1:31 pm

Posting this FYI for the good of the order (v9.0 U2).

On multiple occasions we've encountered seemingly never-ending spinning wheel when attempting to retrieve a SQL Transaction Log list with Explorer for SQL. In every case, this occurred when we had already successfully run a transaction LIST retrieval, then hit the backup button and tried retrieving a different list (same database). We waited 5 - 10 minutes before cancelling.

The solution each time was to fully cancel the Explorer for SQL process and then retry. On the retry, results returned in a less than a minute, as is more typical.


PS- The other potential cause I'd considered is a subsequent Transaction Log backup occurring while Explorer for SQL is running, but I haven't taken the time to validate that.

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

Re: SQL Transaction Retreival Slow (Failing?)

Post by foggy » Aug 25, 2016 1:57 pm

Eric, thanks for bringing our attention to this, we're currently trying to reproduce the described behavior. Will keep you posted.

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

Re: SQL Transaction Retreival Slow (Failing?)

Post by foggy » Aug 26, 2016 12:08 pm

Confirmed. Will be addressed in the future releases. Thanks again!

fcoa
Novice
Posts: 8
Liked: never
Joined: Aug 09, 2016 8:55 pm
Full Name: Eric
Contact:

Re: SQL Transaction Retreival Slow (Failing?)

Post by fcoa » Aug 26, 2016 12:12 pm

Thanks for the prompt attention to the matter.

Out of curiosity, which was the actual cause? Attempting to run multiple transaction retrievals in a single Explorer for SQL session, or another transaction log backup occurring while Explorer for SQL is running.

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

Re: SQL Transaction Retreival Slow (Failing?)

Post by foggy » Aug 26, 2016 12:23 pm

The code causing this behavior is yet to be inspected. So far we've just reproduced the issue in the lab.

corey.ike
Novice
Posts: 5
Liked: 1 time
Joined: Jul 21, 2014 3:33 pm
Full Name: Corey Ike
Contact:

Re: SQL Transaction Retreival Slow (Failing?)

Post by corey.ike » Aug 26, 2016 3:29 pm

Can you tell Support what Bug Number this is so we can track the issue?
Thank you,
Corey Ike
Veeam Support

nathanael.duke
Influencer
Posts: 10
Liked: 3 times
Joined: Apr 28, 2014 4:28 pm
Full Name: Nathanael JonCroft Duke
Contact:

Re: SQL Transaction Retreival Slow (Failing?)

Post by nathanael.duke » Aug 26, 2016 4:13 pm

Also, is this in any way related to the execution priority of the agent? I have worked with one individual who was unable to consistently get log shipping to work on a busy SQL server until he used a third-party tool to forcibly raise the priority of the Log Shipping Agent's process. Unfortunately, the registry value "LowerAgentPriority" being set to 0 did not affect the execution priority of the Log Shipping agent process.

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

Re: SQL Transaction Retreival Slow (Failing?)

Post by foggy » Aug 26, 2016 4:29 pm

Do not have the bug ID yet. I don't think this is priority related.

Post Reply

Who is online

Users browsing this forum: nmdange and 18 guests