Home Forums Article Discussions Article Discussions by Author Discuss content posted by Steve Jimmo Compilation Locks RE: Compilation Locks

  • May 12, 2010 at 10:59 am

    #1166385

    Adi Cohn-120898 (5/12/2010)

    This is not a bug. Rowlock and pagelock are mutually exclusive, and both state to use either row locks or page locks as long as escalation to page locks is not required.

    I think that lock escalation can't escalate to page lock. If I'm not mistaken until SQL Server 2008 lock escalation could escalate directly to table lock and since SQL Server 2008 if the table is partitioned, it can escalate to lock a partition in the table (or few partitions if needed).

    Adi

    Oops. Stupid mistake. My mind said table lock, my fingers typed something else.

    Thanks for pointing it out; I'll see if I can edit the post.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/