SQL Server Performance

What TSQL requests what locks?

Discussion in 'SQL Server 2005 General DBA Questions' started by Trev256, Mar 27, 2009.

  1. Trev256 New Member

    Hi - Is there a whitepaper/bog on what TSQL requests what locks?
    I assume that the update statement requests an update lock. But what about select etc....
    Thanks
  2. MohammedU New Member

    It is all depends on the TSQL and the resources available on the server at the time of execution...
    Check BOL topics LOCK MODES and LOCK ESCLATION etc to find the details of what locks SQL uses and how it esclates...
  3. satya Moderator

    As referred BOL is best resource to look for locking and process of how it obtains one, also seach on the forums for similar issues that were posted & resolved.

Share This Page