I have deadlock graph where the locked resource is pointed out by these three fields DB ID, File ID, Page ID. There's several connected objectid. All I wish to know is exactly what table this site goes. I attempted DBCC PAGE(dbid, fileid, pageid) with tableresults but that does not show any table title.

Any idea ways to get this?

Update: Also attempted SELECT name From sys.indexes WHERE object_id = 123 and Index_id = 456 Here 123 is m_objid (next ObjectId) and 456 is m_indexid (next IndexId) that we get as output for DBCC Page command. All I recieve is NULL.

To obtain is a result of DBCC PAGE you have to enable traceflag 3604, otherwise the outcomes visit the SQL server log:

dbcc traceon (3604)

then try the command

dbcc page ( dbid, filenum, pagenum , 3)

The 4th parameter is printopt:

The printopt parameter has got the following meanings:

0 - print just the page header
1 - page header plus per-row hex dumps and a dump of the page slot array 
    (unless it's a page that doesn't > have one, like allocation bitmaps)
2 - page header plus whole page hex dump
3 - page header plus detailed per-row interpretation

definition from here