Quick Question,

I am running following query from my two different Server. Both have linked
server to one of production server.

Server1.

Select top 1000 * from myLinkServer.MyDB.dbo.MyTable.

Takes 15 seconds

Server 2

Select top 1000 * from myLinkServer.MyDB.dbo.MyTable.

Takes 2 minutes

both servers configuration are same.
both servers temp db size are same.
both servers memory assign to SQL Server are same.
LAN card are same.
No variation in internet.

Any idea? Or any hint.

Well.. 2 questions I would have to beg are:
1. Does the MyTable in each server have the same number of rows?
2. Instead of specifying * try specifying the column names that you want to
retrieve.
Have you tried doing that? I would be curious to see if the rows were
returned
any faster.

SQL Squirrel
http://www.lockergnome.com/sqlsquirrel/

"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote

1. Does the MyTable in each server have the same number of rows?

YES

2. Instead of specifying * try specifying the column names that you want to
retrieve.

My main concern is when I run the query from Server2 , howcome it's fast?

Thanks



"SQL Squirrel" <brett.sqldba (AT) gmail (DOT) com> wrote