Databases
StackOverflow2013
Postsdbo
POLinked Server Performance and options
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POLinked Server Performance and options
    primarykey
    data
    text
    <p>At work we have two servers, one is running an application a lot of people use which has an SQL Server 2000 back end. I have been free to query this for a long time but can't add anything to it such as stored procedures or extra tables. </p> <p>This has lead to us having a second SQL Server linked to the first one and me building up a library of stored procedures that query data from both sides using linked server. Some of these queries are taking longer than what I would like. </p> <p>Can someone point me to some good articles about using linked servers? I am particularly interested in finding out what data is being transferred between the two as usually the majority of the sql statement could be performed remotely but I have the feeling it may be transferring the full tables, it is usually just a join to a small final table locally.</p> <p>Also what do the linked server options do I currently have:</p> <ul> <li>Collation Compatible True</li> <li>Data Access True</li> <li>Rpc True</li> <li>Rpc Out True</li> <li>Use Remote Collation False</li> <li>Collation Name (Blank)</li> <li>Connection Timeout 0</li> <li>Query Timeout 0</li> </ul> <p><strong>EDIT:</strong></p> <p>Just thought I would update this post I used openqueries with dynamic parameters for a while to boost performance, thanks for the tip. However doing this can make queries more messy as you end up dealing with strings. finally this summer we upgraded SQL Server to 2008 and implemented live data mirroring. To be honest the open queries were approaching the speed of local queries for my tasks but the mirroring has certainly made the sql easier to deal with.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarc_s
    1. USPeteT
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POLinked Server Performance and options
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POLinked Server Performance and options
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POLinked Server Performance and options
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload