Linked server on SQL 2000 and 2008 run very slow.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Linked server on SQL 2000 and 2008 run very slow.

Author

Topic

NguyenL71
Posting Yak Master

228 Posts

Posted - 2011-07-14 : 18:44:36

[code][code]I have a linked server setup between sql 2000 and sql 2008 r2 but it run very slow. it was working fine with SQL 2005 since we upgrade to SQL 2008 R2.
Is there any tips that you can provide to help it run faster or you know website provide such info. I google but haven't found any values info.

Any help would greatly appreciate.[/code][/code]

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-14 : 19:55:11

Check the execution plan. Update statistics with fullscan.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

NguyenL71
Posting Yak Master

228 Posts

Posted - 2011-07-14 : 23:43:16

There is a nightly job to rebuild indexes and update statistics.  Is
there any twist in the setting up need extra attention.

Thanks in advance.

quote:
Originally posted by tkizer

Check the execution plan. Update statistics with fullscan.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-15 : 00:23:32

View the execution plan to see what's going on.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources