Are there any performance caveats for using linked servers ? We have an sql server storing small bits of dynamic data for our corporate website... session guids etc. Also, the website needs to access our live subscription system to show what products a user is subscribed to etc. I decided I did not want the website code (asp.net, could be many as yet undisclosed exploits) directly hitting our live subs server in anyway, and so I added the subs server to the website sql server as a linked server. The website then only ever calls stored procedures on the website sql server, which in turn calls across to the linked subs server using a heavily restricted login. Anyone have any comments about this architecture ? Sometimes the website appears to stall and then times out. I have not yet ascertained whether this refers to the http connection to the web service, or the database connection from the web service to the website sql server. Thanks for any comments.