Locking and Transactions /w Linked Servers

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Brandon Slezak (Slezak_at_discussions.microsoft.com)
Date: 12/06/04 

Date: Mon, 6 Dec 2004 14:57:02 -0800

Hi All,

How exactly does Sql Server lock data when the transaction is across
multiple servers? Assume a default isolation level and no special locking
command.

For instance if Server A says

BEGIN TRAN
INSERT INTO Customers
OR
SELECT * FROM Customers
COMMIT TRAN

How will users on Server B be effected if they are trying to access data in
the Customers table natively on Server B? Does Sql Server issue intent
locks? How does DTC know what kind of locks to issue on Server B?

-Thanks!

-Brandon

Relevant Pages

  • Re: Locks, Scope & Performance
    ... A query that brings the server to its knees is often a sign ... Would the process you are suggesting look like a proc that calls a sub> proc ... > and creates w/recompile an inner sProc? ... >> page locks or no locks instead. ...
    (microsoft.public.sqlserver.programming)
  • Re: In-memory caches and app server load-balancing
    ... The locks are in-memory locks on each application server. ... the cache synchronisation should not bring down the performance. ... When a client needs to lock ...
    (comp.os.linux.development.apps)
  • Re: In-memory caches and app server load-balancing
    ... The locks are in-memory locks on each application server. ... the cache synchronisation should not bring down the performance. ... When a client needs to lock ...
    (comp.os.linux.development.system)
  • Re: In-memory caches and app server load-balancing
    ... The locks are in-memory locks on each application server. ... the cache synchronisation should not bring down the performance. ... When a client needs to lock ...
    (comp.os.linux.development.system)
  • RE: Problems with Code Coverage and Team Build
    ... How do you clear locks on files on the build server. ... It is capable of finding out the process that locks a certain file. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.vsnet.enterprise.tools)