Re: linked server issue
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 30 Oct 2007 22:32:40 +0000 (UTC)
MO (MO@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Server 1 is a linked server on server 2. I have a process that does a
bunch of selects/inserts on server 2 and also does an update to 1 table
on server 1 using the linked server. When this process runs, what we see
is that 95% of the time is spent in the update to 1 table on server 1
and all other operations on server 2 gets done quickly. When I run the
update on server 1 as a local process it completes fast.
To solve this issue, I am thinking of setting up of a local proc on
server 1 that updates the table and making a call to server 1 form
server 2. Will this solve my problem ?
Maybe. We don't know who that UPDATE statement looks like and what it does.
Do you update the table on Server1 with data from Server2?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Business Admin Permissions
- Next by Date: Re: ddl admin privilage
- Previous by thread: Re: linked server issue
- Next by thread: Link Server Access Rights
- Index(es):
Relevant Pages
|
|
