Which Object(s) Containting in a Specific Page On SQL.
-
I have this result from sysprocesses.
lastwaittype waitresource
------------------ -------------
PAGEIOLATCH_SH 11:3:168217
I Know that the
11 (from waitresource) is the DB id
3 is the datafile ID
and 168217 is the page on datafile.
I Don't Know the way to find Which Object(s) Containting in this Page
Thanx!
-
Now, if you got all information collected you should be able to use DBCC PAGE like this:
DBCC TRACEON(3604)
DBCC PAGE (11 < or db name >, 3, 168217, 3)
The undocumented DBCC EXTENTINFO might also be interesting. Google for its' use.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Just in addition to what Frank advised, under pageheader, m_objId gives you the object id
-
Thank You
-
Hi,
Something new is something to investigate....
selecting some IOlatches (select * from sysprocesses) and using these waitresource numbers for executing
dbcc traceon(3604)
dbcc page(9,1,15805,1)
gave a lot of results but can anyone tell me how to translate them?
GKramer, The Netherlands
*************************************************************
PAGE: (1:15805)
---------------
BUFFER:
-------
BUF @0x00F2DA80
---------------
bpage = 0x50244000 bhash = 0x00000000 bpageno = (1:15805)
bdbid = 9 breferences = 1 bstat = 0x9
bspin = 0 bnext = 0x00000000
PAGE HEADER:
------------
Page @0x50244000
----------------
m_pageId = (1:15805) m_headerVersion = 1 m_type = 3
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8
m_objId = 2 m_indexId = 255 m_prevPage = (0:0)
m_nextPage = (0:0) pminlen = 0 m_slotCnt = 12
m_freeCnt = 7005 m_freeData = 5467 m_reservedCnt = 1710
m_lsn = (149609:532:27) m_xactReserved = 1710 m_xdesId = (0:138882555)
m_ghostRecCnt = 0 m_tornBits = 49
Allocation Status
-----------------
GAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED
PFS (1:8088) = 0x41 ALLOCATED 50_PCT_FULL DIFF (1:6) = NOT CHANGED
ML (1:7) = NOT MIN_LOGGED
DATA:
-----
Slot 6, Offset 0x12d4
---------------------
Record Type = BLOB_FRAGMENT Record Attributes =
502452D4: 02870008 7fbc0000 00000000 00040003 ................
502452E4: f4740000 959a00b6 006b0000 00000000 ..t.......k.....
502452F4: 006b0000 00000000 00000000 aaab0000 ..k.............
50245304: 00003eaa 00000000 00000000 00000000 .>..............
50245314: 00000000 00000000 00000000 00000000 ................
50245324: 00000000 00000000 00000000 00000000 ................
50245334: 00000000 00000000 00000000 00000000 ................
50245344: 00000000 00000000 00000000 00000000 ................
50245354: 00000000 00000000 00000000 00000000 ................
50245364: 00000000 00000000 00000000 00000000 ................
50245374: 00000000 00000000 00000000 00000000 ................
50245384: 00030000 006b0000 00010000 00100000 ......k.........
50245394: 00000000 00004100 000042d6 00000000 .....A...B......
502453A4: 00004100 00000000 00000000 00000000 .A..............
502453B4: 00000000 00000000 00000000 00000000 ................
502453C4: 00000000 00000000 00000000 00000000 ................
502453D4: 00000000 00000000 00000000 00000000 ................
502453E4: 00000000 00000000 00000000 00000000 ................
502453F4: 00000000 00000000 00000000 00000000 ................
50245404: 00000000 00000000 00000000 00000000 ................
50245414: 00000000 00000000 00000000 00000000 ................
50245424: 00000000 003e001f 00000000 00000000 ......>.........
50245434: 00000000 00000000 00000000 00000000 ................
50245444: 00000000 00000000 00000000 00000000 ................
50245454: 00000000 00000000 00000000 00000000 ................
50245464: 00000000 00000000 00000000 00000000 ................
50245474: 00000000 00000000 00000000 00000000 ................
50245484: 00000000 00000000 00000000 00000000 ................
50245494: 00000000 00000000 00000000 00000000 ................
502454A4: 00000000 00000000 00000000 00000000 ................
502454B4: 00000000 00000000 00000000 00000000 ................
502454C4: 00000000 00000000 00000000 00000000 ................
502454D4: 00000000 00000000 00000000 00000000 ................
502454E4: 00000000 00000000 00000000 00000000 ................
502454F4: 00000000 00000000 00300000 00000010 ..........0.....
50245504: 00004190 00000000 00040000 1f000100 .A..............
50245514: 50004f00 53004900 10003000 98000000 .O.P.I.S.0......
50245524: 00000041 00000000 00000400 001f0001 A...............
50245534: 0070006f 0035006e 00100030 428c0000 o.p.n.5.0......B
50245544: 00000000 00000000 01000004 56001f00 ...............V
50245554: 53005200 003100 .R.S.1.
Slot 7, Offset 0x60
-------------------
Record Type = BLOB_FRAGMENT Record Attributes =
50244060: 00540008 7fbc0000 00000000 00050004 ..T.............
50244070: 00000001 00000004 00000279 00003dbd ........y....=..
50244080: 00060001 00403699 00000000 0082d8b2 .....6@.........
50244090: 00000004 016f622c 016f6268 011b2bd0 ....,bo.hbo..+..
502440A0: 016f61ec 004035d7 016f627e 016f6268 .ao..5@.~bo.hbo.
502440B0: 0054763e >vT.
Slot 8, Offset 0xb4
-------------------
Record Type = BLOB_FRAGMENT Record Attributes =
502440B4: 00540008 7fbd0000 00000000 00050004 ..T.............
502440C4: 00000001 00000004 00000b2f 00000a1b ......../.......
-
I guess your best bet is to read this in "Inside SQL Server". Or just google on this. It would be a very long explanation here.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
for all who are interested.... see page 248 and up.
Thanks Frank...
GKramer
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply