We have an up and running web application. Yesterday we added two more systems to our application. The two systems are connected to our SQl Server through WAN using sp_addlinked server. Now the performance of our system has gone down like anything. When we removed the linked server the performance was good. When the linked servers were established, the performance is going down. Does linking servers from remote locations cause perfromance issues. The two servers at other locations have only select privileges on our database.

P.C. Vaidyanathan