September 17, 2014 at 6:37 am
Hi,
I am executing several stored procedures for my reports. The report database has to get the data from Prod. We have two different production boxes. Some databases are in Production 1 and some are in production 2. We created the linked servers from the report instance to the the production 1 and production 2. All are Sql servers only
We have one report executing on daily basis. That report is taking long time. The Data time retrieval itself taking long time (4hr). When I see the execution plan for the sprocedure, it is showing remote query cost.
I need to tune that. Pls provide any links related to linked server query tuning.
September 19, 2014 at 7:32 am
you need to break that report down to find the query that is causing the long remote server execution.
once you have found the query, run it directly on the remote server the is causing the delay. (assuming the remote server is one of the SQL servers)
It will be much easier to tune this way. while doing this set the query to return the actual execution plan, this should give you more useful info when not run remotely.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply