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.
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
ObjectId) and 456 is
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
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