January 14, 2005 at 2:49 am
Morning All,
Has anyone encountered a problem whereby communication between linked servers (standard sql server linked server, not oledb) is slower in one direction than the other?
we currently have a setup where performing the same query results in very different speed increases, depending on what server the linked server resides?
any opinions would be appreciated,
-- Alex
January 16, 2005 at 8:29 am
Hi Alex,
It looks like server where your query has bad performance does not have regular maintenance (update statistics, reindex etc.). Check execution plan in all cases.
Use rather OPENROWSET and OPENQUERY than four path reference for tables 'server.database.owner.table'.
Regards,
Milovan
January 17, 2005 at 3:42 am
hiya, thanks for your response.
stats are updated nightly and indexes rebuilt on a weekly basis.
how does openrowset differ from the 4 part name? (under the hood)
-- Alex
January 17, 2005 at 3:45 am
I've seen it before where a query from a remote server doesn't use the approriate index when executing, mind you, that was a year ago on a SQL 7 box so maybe it doesn't apply here.
January 17, 2005 at 4:00 am
it just so happens Mike, that these are 7 boxes. How did you get around it / force it to use the right index - just using hints?
-- Alex
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply