Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

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)
0
tesla764
Asked:
tesla764
1 Solution
 
Aaron ShiloCommented:
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

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Tackle projects and never again get stuck behind a technical roadblock.
Join Now