SQL Server linked server performance

nakliyatci

New Member
I am using SQL Server 2008 Enterprise. And I am using Linked Server technologies to link another SQL Server 2008 Enterprise instance from another server. I write TSQL to manipulate objects (e.g. tables) from both server instances.My question is, for linked server, is there a big performance issue? If yes, what is the key performance bottleneck and best practice we should follow?thanks in advance,George
 
Top