Solved

otential performance differences between the following 3 SQL statements

Posted on 2011-02-24
2
292 Views
Last Modified: 2012-05-11
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
Comment
Question by:tesla764
2 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
ID: 34972081
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
 

Author Closing Comment

by:tesla764
ID: 35140117
Thanks
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question