Re: linked server issue

MO
How much data do you update ? You can create a stored procedurea on S1 and
run it from S2

EXEC S1.dbname.dbo.sp

or if you are on SQL Server 2005 another method is
EXECUTE ('select......') AT S1


"MO" <MO@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:886A3F9C-633C-45F3-8829-CB7FA2779210@xxxxxxxxxxxxxxxx
Hi,
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 ? If not what else can I try ?
TIA
MO


.

Relevant Pages

  • RE: Linked server strangeness in SQL 2005 Mgmt Studio
    ... I understand that you found that after you added the linked server ... I would like to check with you if SQL Server ... EXEC master.dbo.sp_addlinkedsrvlogin ...
    (microsoft.public.sqlserver.connect)
  • Re: OPENQUERY - Access denied
    ... Try to set Allow InProcess option in linked server provider options ... EXEC master.dbo.sp_addlinkedserver @server = N'OLAP_SERVER', ...
    (microsoft.public.sqlserver.olap)
  • Re: Linked Server Security Trouble
    ... We do have a Windows ... SQL Server MVP ... Authentication for this Linked Server. ... exec sp_dropserver @ServerName ...
    (microsoft.public.sqlserver.security)
  • Re: OPENQUERY - Access denied
    ... The one that would not work for me is OPENQUERY. ... In the meantime the server was rebooted for maintenance. ... Here is the script to create the linked server: ... EXEC master.dbo.sp_addlinkedserver @server = N'OLAP_SERVER', ...
    (microsoft.public.sqlserver.olap)
  • Re: Linked Server Security Trouble
    ... Can you offer any recommendations on other ways to configure a linked server ... We do have a Windows ... exec sp_dropserver @ServerName ...
    (microsoft.public.sqlserver.security)