July 20, 2013 at 4:26 pm
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?
July 21, 2013 at 3:34 am
I have noticed the most likely issues with linked server performance, relates to
1) network delays
2) IO related waits.
Probably you need to figure out where the issue is occurring, running traces or using tools to monitor.
July 21, 2013 at 3:54 am
balasach82 (7/20/2013)
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?
Not likely. That is, you had no reason to expect any improvement just because you upgraded to SQL 2008. Had you upgraded to SQL 2012 SP1 - maybe.
Anyway, to give you any actual help, we would need to see the queries (as a start), and we would also need to know about the login mapping. That is, the user that runs the local queries, what does that map to on the remote server?
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply