otential performance differences between the following 3 SQL statements

Based on the listed assumptions, what are the potential performance differences between the following 3 SQL statements?  All statements are run on Server A.

>> select * from CustData..Cust c join CustData..Dept d on (c.DeptID = d.DeptID)

LinkServerA: Linked server definition, defined on Server A, that points back to itself

>> select * from CustData..Cust c join LinkServerA.CustData..Dept d on (c.DeptID = d.DeptID)

LinkServerB: Linked server definition, defined on Server A, that points to remote Server B

>> select * from CustData..Cust c join LinkServerB.CustData..Dept d on (c.DeptID = d.DeptID)
tesla764Asked:
Who is Participating?
 
Aaron ShiloChief Database ArchitectCommented:
hi
one thing i ran into is that Because linked server is using OS memory rather than the buffer pool and if there is not enough memory, your query performance will degrade.


--------------------------------------------------------------------------------
0
 
tesla764Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.