Sunday, July 21, 2013

[SQL Server 2008 issues] SQL 2008 - LInked Server performance woes

[SQL Server 2008 issues] SQL 2008 - LInked Server performance woes


SQL 2008 - LInked Server performance woes

Posted: 20 Jul 2013 09:26 AM PDT

We had a linked server from SQL 2008 to SQL 2005 and perfroming inserts/updates/deletes in SQL 2008. Almost always, it was running for 6hrs (data volume doesnt seem to make much difference). Now, SQL 2005 is upgraded to 2008, still i see the same duration. Is there any setting which i might have missed?

No comments:

Post a Comment

Search This Blog