If you have page level lock information (ex: PAG: 8:1:2234094), how do you
determine what table is associated with that page?

Thanks!

use DBCC PAGE to dump the page & read m_objId from the page header... eg,
run the following from the Query Analyser:

dbcc traceon(3604)
go
dbcc page (8, 1, 2234094, 1)
go

Regards,
Greg Linwood
SQL Server MVP

Show quoteHide quote

While DBCC PAGE is not supported, you can see examples of its use here:

http://www.ctlcorp.com/support/sql/support1.html

Which will allow you to manually get down to the table (and index) involved.




Show quoteHide quote

Thanks guys, exactly what I was looking for.  FYI - that link references the
usage of DBCC PAGE from SQL 6.0 and the syntax has changed in 2000.  I
probably should have specified what version I was using, but thought I would
give some feedback for future reference :)

Why is Count(*) slow?
Bad datetime values stored by SQL Server 2000
Bitwise operations on BigInt
Upsized SQLServer app 100x slower than MsAccess
Where clause in variable?