Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Deadlock involving Identity Column Expand / Collapse
Author
Message
Posted Tuesday, September 10, 2013 11:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 11, 2014 9:35 AM
Points: 7, Visits: 161
This indicates a text mix page which is new to me. The object id is the table. My issue may be more isolation level than the clustering as I previously thought. Thanks for pointing me in a different direction.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.



PAGE: (1:1662692)





BUFFER:





BUF @0x03CC8A0C



bpage = 0x5CC52000 bhash = 0x00000000 bpageno = (1:1662692)

bdbid = 5 breferences = 3 bUse1 = 24899

bstat = 0x4c00009 blog = 0x159a2159 bnext = 0x00000000



PAGE HEADER:





Page @0x5CC52000



m_pageId = (1:1662692) m_headerVersion = 1 m_type = 3

m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8000

m_objId (AllocUnitId.idObj) = 8934 m_indexId (AllocUnitId.idInd) = 256

Metadata: AllocUnitId = 72057594623426560

Metadata: PartitionId = 72057594510245888 Metadata: IndexId = 1

Metadata: ObjectId = 1806785644 m_prevPage = (0:0) m_nextPage = (0:0)

pminlen = 0 m_slotCnt = 38 m_freeCnt = 542

m_freeData = 7840 m_reservedCnt = 0 m_lsn = (87842:11032:62)

m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0

m_tornBits = 338776153



Allocation Status



GAM (1:1533696) = ALLOCATED SGAM (1:1533697) = NOT ALLOCATED

PFS (1:1658040) = 0x43 ALLOCATED 95_PCT_FULL DIFF (1:1533702) = NOT CHANGED

ML (1:1533703) = NOT MIN_LOGGED





DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Post #1493294
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse