Linking table Name to PageId

• Nikita-395727

  SSC Eights!

  Points: 898

  More actions

  September 10, 2009 at 1:20 pm

  #210641

  Hello,

  I was capturing some blocking info for overnight processes. I have the info captured last night on blocking spids, dbcc inputbuffer , wait type.

  Almost all the blocked SPIDs ( total 7 SPIDS ) were waiting for page 8:1:9022334 with lock type LCK_M_S.

  I do not know how to find out which object the wait was happening on.

  Is there any way to find out? I have reindexed the tables after this blocking info was captured in case that affects the numbers.

  Thanks,

  Nikki :w00t:

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  September 10, 2009 at 1:34 pm

  #1051926

  Try DBCC PAGE

  -Roy

• umar iqbal

  SSCommitted

  Points: 1703

  More actions

  September 10, 2009 at 1:43 pm

  #1051932

  8:1:9022334

  db id. index(clustered/nonclustered).objectid

  TRY this and it will give you object name

  select OBJECT_NAME(9022334 ) from sys.objects

  :crazy: :alien:

  Umar Iqbal