Locks/Object window

• @DJ

  SSCommitted

  Points: 1989

  More actions

  February 11, 2005 at 3:44 am

  #163733

  Hi

  I am lookinG at Locks/Object window in enterprise manager.

  There I get a window giving me the process id, lock type mode and so on. Those are easy to figure out, but the last one,"Resources", well I simply do not understand what it means.

  I get a number like this: 1:2000171:2. According to the help display the resource I am looking at is of type PAG and means "Page Number. The page is identified by a field:page combination, where the field is the field in the sysfile table, and page is the logical page number within that file."

  Anyone care to translate?

  I was trying to figure out if I could monitor one singel population of a table, can this be done?

   

  Regards

  DJ

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  February 11, 2005 at 4:57 pm

  #541917

  it's not "field" but "FileId"

  This is the file id from SYSFILES system table in that database which indicates the OS file ( ".dat" ) that the data resides on.

  page number is the logical page on that device/file

  and row number on that page is the last value.

  So that's file #1, page #2000171, and row #2 on that page.

  Try and find info on DBCC PAGE for dumping the contents.

  (this is as best as I recall, it's been a while)

   

   

• longname

  SSC Rookie

  Points: 34

  More actions

  May 25, 2006 at 7:49 am

  #640040

  There is a column named 'Index' in Locks/Object view. What's that mean?

  Index in tempdb?