Connection Timeout Linked Server

Question

I have created a linked server from one SQL Server 2005 to Another 2005. When I run an update query through the SQL Server Management Studio (SSMS), it runs in under a second. If I run the query through a asp webpage it times out. I ran SQL Profiler to see if I noticed anything as well as the Activity Monitor in SSMS and all I found was that a lock was being created (Wait type LOCK_M_U), but I can't find what is locking it. Any help would be appreciated.

Wade

Community · Accepted Answer · 2017-05-23 09:58:16Z

0

It could be that the user account that you run under in SSMS and from the ASP page have different permissions on the linked server, which could lead to a difference in which query plans it uses when running your update. See this answer to a more generic question about linked server performance.

edited May 23, 2017 at 9:58

CommunityBot

11 silver badge

answered Jan 6, 2011 at 4:48

patmortech

10.2k6 gold badges41 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Wade73 · Accepted Answer · 2011-01-11 18:58:57Z

0

The issue seems to be with the ADO activeX component, since I used ASP.Net and it worked flawlessly. Oh well.

answered Jan 11, 2011 at 18:58

Wade73

4,5193 gold badges35 silver badges49 bronze badges

Collectives™ on Stack Overflow

Connection Timeout Linked Server

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related