THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Indexes » locking   (RSS)
  • Geek City: Controlling Lock Granularity

    In all versions of SQL Server since 7.0, the engine could choose to lock rows, pages or the entire table. In addition, even if it starts out your query execution by obtaining row or page locks, if too many locks are acquired, SQL Server could escalate to a table lock.  Each lock uses memory, so when escalation replaces the thousands of ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on May 3, 2009
Privacy Statement