January 11, 2010 at 2:30 am
Hi All,
We have 2 servers (A and B). when we run remote query from B to A using linked server, sometimes nto all the rows are being transfered. but if i run manually the same process again all the rows are transfered.
the version and SP on the server is:
Microsoft sql server 2005 Service Pack 3 - 9.00.4054.00 standar edition on windows nt 5.2 SP2
regards,
Hernan Gomelsky
January 11, 2010 at 8:14 am
It depends on what you are doing.
If you are running queries that join between tables in the two server instances, and transferring large amounts of data, then you have a bottleneck that you need to be aware of.
If the servers are on their own subnet with a 1GB link, then you should not have to worry a great deal. I would be concerned if the two servers are connected by a shared, slow link.
HTH...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2010 at 1:16 am
Hi and thanks for your answer!
About the query it has not join, only simple select.
the query is something like this:
select * from openquery([LinkedServerName],'select X,y,z from AB')
"transferring large amounts of data": is 14K or 20K a large amount?
Anyway if i have bottleneck...i will see that as missing rows or as a timeout?
About the subnet i really dont know the details, how can i check it? the servers are from a customer.
thanks a lot again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply