Can someone decipher the Lock Mode Column in Profiler for me?

  • When I run a Profiler session looking for locks, Profiler displays the mode as a number. I have searched all over to see which lock mode these numbers refer to. Mostly it's 1, 3 and 6.

    The modes are displayed the same in both SQL 2000 and SQL 2005 Profilers. I am running Profiler against a SQL 2000 DB.

    Thanks,

    Art

  • check BOL for the system table syslockinfo, it will give you the info on all, but 1,3,6;

    1 = Sch-S (Schema stability). Ensures that a schema element, such as a table or index, is not dropped while any session holds a schema stability lock on the schema element.

    3 = S (Shared). The holding session is granted shared access to the resource.

    6 = IS (Intent Shared). Indicates the intention to place S locks on some subordinate resource in the lock hierarchy.

  • Thanks, Bob!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply