September 16, 2014 at 7:25 am
Hi,
One of the report execution is taking long time.
The request type is 'subscription', Format is 'excelopenxml', reportaction is 'render', source is 'live'.
TimeDataRetrieval is very high compare to the TimeProcessing and TimeRendering.
When I see the execution plan of one of the sproc it is showing remote query cost is very high.
Is there any way to optimize this report? How can we reduce the remote query cost
September 16, 2014 at 11:52 am
Okay, a remote query is usually when you are accessing data across a linked server. Unless user setup to access the linked server has elevated permissions it does not have access to statistics on the linked server so you can't get a truly optimized plan.
What I usually try to do when forced to use a linked server, is to do as much processing on the linked server as possible and bring back a minimal set of data. My best success has been to create a stored procedure on the linked server that I call and use it to populate a temp table which I use in the rest of my query.
Without seeing the query there isn't a whole lot more I can offer.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply