May 12, 2011 at 11:21 am
I am running a trace on a sql server database. I do see a timeout and here is what it looks like at least first two columns:
Event Class Text
Lock:Timeout 1:1230531
What does 1:1230531 mean?
there is no such object when I run this query:
SELECT *
FROM sys.objects
WHERE object_id = 1230531
thanks
May 12, 2011 at 11:32 am
Looks like a page. The FileID:PageID is how SQL refers to a specific page. Read up on DBCC Page (undocumented) for getting the ID of the table that owns the page.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2011 at 11:42 am
tried this:
DBCC PAGE('test',110,1230531,3) WITH TABLERESULTS
GO
but doesn't really work
May 12, 2011 at 11:49 am
Ran it again and it worked:
DBCC PAGE('test',1,1230531,3) WITH TABLERESULTS
GO
here is what I have.. but I don't think it tells me anything.
BUFFER:BUF @0x0000000244FD1600bpage0x0000000244458000
BUFFER:BUF @0x0000000244FD1600bhash0x0000000000000000
BUFFER:BUF @0x0000000244FD1600bpageno(1:1230531)
BUFFER:BUF @0x0000000244FD1600bdbid110
BUFFER:BUF @0x0000000244FD1600breferences0
BUFFER:BUF @0x0000000244FD1600bUse17211
BUFFER:BUF @0x0000000244FD1600bstat0xc00109
BUFFER:BUF @0x0000000244FD1600blog0x21597979
BUFFER:BUF @0x0000000244FD1600bnext0x0000000000000000
PAGE HEADER:Page @0x0000000244458000m_pageId(1:1230531)
PAGE HEADER:Page @0x0000000244458000m_headerVersion1
PAGE HEADER:Page @0x0000000244458000m_type2
PAGE HEADER:Page @0x0000000244458000m_typeFlagBits0x4
PAGE HEADER:Page @0x0000000244458000m_level0
PAGE HEADER:Page @0x0000000244458000m_flagBits0x0
PAGE HEADER:Page @0x0000000244458000m_objId (AllocUnitId.idObj)8575
PAGE HEADER:Page @0x0000000244458000m_indexId (AllocUnitId.idInd)256
PAGE HEADER:Page @0x0000000244458000Metadata: AllocUnitId72057594599899136
PAGE HEADER:Page @0x0000000244458000Metadata: PartitionId72057594535673856
PAGE HEADER:Page @0x0000000244458000Metadata: IndexId17
PAGE HEADER:Page @0x0000000244458000Metadata: ObjectId923150334
PAGE HEADER:Page @0x0000000244458000m_prevPage(1:1230530)
PAGE HEADER:Page @0x0000000244458000m_nextPage(1:1230532)
PAGE HEADER:Page @0x0000000244458000pminlen28
PAGE HEADER:Page @0x0000000244458000m_slotCnt32
PAGE HEADER:Page @0x0000000244458000m_freeCnt6448
PAGE HEADER:Page @0x0000000244458000m_freeData3322
PAGE HEADER:Page @0x0000000244458000m_reservedCnt0
PAGE HEADER:Page @0x0000000244458000m_lsn(231914:66:2)
PAGE HEADER:Page @0x0000000244458000m_xactReserved0
PAGE HEADER:Page @0x0000000244458000m_xdesId(0:114620284)
PAGE HEADER:Page @0x0000000244458000m_ghostRecCnt0
PAGE HEADER:Page @0x0000000244458000m_tornBits747446466
PAGE HEADER:Allocation StatusGAM (1:1022464)ALLOCATED
PAGE HEADER:Allocation StatusSGAM (1:1022465)NOT ALLOCATED
PAGE HEADER:Allocation StatusPFS (1:1229376)0x40 ALLOCATED 0_PCT_FULL
PAGE HEADER:Allocation StatusDIFF (1:1022470)CHANGED
PAGE HEADER:Allocation StatusML (1:1022471)NOT MIN_LOGGED
thoughts?
May 12, 2011 at 3:31 pm
sqlstar2011 (5/12/2011)
BUFFER:BUF @0x0000000244FD1600bpage0x0000000244458000BUFFER:BUF @0x0000000244FD1600bhash0x0000000000000000
BUFFER:BUF @0x0000000244FD1600bpageno(1:1230531)
BUFFER:BUF @0x0000000244FD1600bdbid110
BUFFER:BUF @0x0000000244FD1600breferences0
BUFFER:BUF @0x0000000244FD1600bUse17211
BUFFER:BUF @0x0000000244FD1600bstat0xc00109
BUFFER:BUF @0x0000000244FD1600blog0x21597979
BUFFER:BUF @0x0000000244FD1600bnext0x0000000000000000
PAGE HEADER:Page @0x0000000244458000m_pageId(1:1230531)
PAGE HEADER:Page @0x0000000244458000m_headerVersion1
PAGE HEADER:Page @0x0000000244458000m_type2
PAGE HEADER:Page @0x0000000244458000m_typeFlagBits0x4
PAGE HEADER:Page @0x0000000244458000m_level0
PAGE HEADER:Page @0x0000000244458000m_flagBits0x0
PAGE HEADER:Page @0x0000000244458000m_objId (AllocUnitId.idObj)8575
PAGE HEADER:Page @0x0000000244458000m_indexId (AllocUnitId.idInd)256
PAGE HEADER:Page @0x0000000244458000Metadata: AllocUnitId72057594599899136
PAGE HEADER:Page @0x0000000244458000Metadata: PartitionId72057594535673856
PAGE HEADER:Page @0x0000000244458000Metadata: IndexId17
PAGE HEADER:Page @0x0000000244458000Metadata: ObjectId923150334
PAGE HEADER:Page @0x0000000244458000m_prevPage(1:1230530)
PAGE HEADER:Page @0x0000000244458000m_nextPage(1:1230532)
PAGE HEADER:Page @0x0000000244458000pminlen28
PAGE HEADER:Page @0x0000000244458000m_slotCnt32
PAGE HEADER:Page @0x0000000244458000m_freeCnt6448
PAGE HEADER:Page @0x0000000244458000m_freeData3322
PAGE HEADER:Page @0x0000000244458000m_reservedCnt0
PAGE HEADER:Page @0x0000000244458000m_lsn(231914:66:2)
PAGE HEADER:Page @0x0000000244458000m_xactReserved0
PAGE HEADER:Page @0x0000000244458000m_xdesId(0:114620284)
PAGE HEADER:Page @0x0000000244458000m_ghostRecCnt0
PAGE HEADER:Page @0x0000000244458000m_tornBits747446466
PAGE HEADER:Allocation StatusGAM (1:1022464)ALLOCATED
PAGE HEADER:Allocation StatusSGAM (1:1022465)NOT ALLOCATED
PAGE HEADER:Allocation StatusPFS (1:1229376)0x40 ALLOCATED 0_PCT_FULL
PAGE HEADER:Allocation StatusDIFF (1:1022470)CHANGED
PAGE HEADER:Allocation StatusML (1:1022471)NOT MIN_LOGGED
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply