Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hydtohou
Starting Member
24 Posts |
 Posted - 2006-08-16 : 10:14:24
|
| Hi I want to do something like this select * from Server1.Database1.dbo.table1 as a JOIN Server2.Database2.dbo.table2 as b ON a.ID = b.ID I wanna know how much performance effect does it have if i join tables in two seperate servers in two different machines.Does any one know any good articles which discusses this.Thanks. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-08-16 : 10:24:21
|
the main thing to consider is how much data you transfer between servers.so if you can limit the returned rows from each server by as much as you can before joining them.if possible put the rows from one server to another in a temp table and do all the work on only one server.also if your doing transactional stuff (multiple updates/inserts selects in one transaction), they're going to be much slower because of distributed transaction manager's keeping it all in sync.main problem is data transfer over network.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
|
|
|
JOIN PERFORMANCE