Query slow over liked server 
Author Message
 Query slow over liked server
Hi,

I have a problem with a query runing on a linked server.

When I execute the following on the target server the query takes about 2
secs
UPDATE TableName
SET MarkedForXfer = 0
WHERE MarkedForXfer = 1

When I execute the following on a linked server from another server the
query takes about 30 mins
UPDATE SQLLinkedServer.Database.dbo.TableName
SET MarkedForXfer = 0
WHERE MarkedForXfer = 1

Has anyone got any Ideas why this would be?

Thanks
Devron



Sat, 22 Jan 2005 10:31:05 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Likes CAT and Sport Query

2. Query (SQL Server 7.0 - Windows 2000 Server) too slow

3. slow queries on a novel 5.0 server, fast on an NT server and on win9x

4. Insert into SQL Server slow, slow, slow...

5. Liked Server to SYBASE

6. Liked Server with insert trigers

7. Query getting slower and slower...

8. slow slow query

9. Query getting slower and slower.....

10. Queries run from server very slow

11. Slow query to remote MSDE (SQL server)

12. Slow queries from Access to MSSQL server


 
Powered by phpBB® Forum Software