Examining the Data Page Structure
In this example, one data page is output from the table “discounts”, found in the “pubs” database, using this code:
| USE pubs GO DBCC TRACEON (3604) GO DECLARE @pgid int SELECT @pgid = first FROM sysindexes WHERE id = object_id(‘discounts’) DBCC PAGE (pubs, @pgid, 1) GO |
This is the result from my computer:
| PAGE: Page found in cache. BUFFER: Buffer header for buffer 0xf96580 page=0x1181000 bdnew=0xf96580 bdold=0xf96580 bhash=0x0 bnew=0xf964c0 bold=0xf96640 bvirtpg=2540 bdbid=5 bpinproc=0 bkeep=0 bspid=0 bstat=0x1004 bpageno=488 PAGE HEADER: Page header for page 0x1181000 pageno=488 nextpg=0 prevpg=0 objid=544004969 timestamp=0001 0000486a nextrno=3 level=0 indid=0 freeoff=122 minlen=5 page status bits: 0x100,0x1 DATA: Offset 32 – 01181020: 0100017e 041a0049 6e697469 616c2043 …~…Initial C 01181030: 7573746f 6d657202 1707 ustomer… Offset 58 – 0118103a: 0401019e 02200056 6f6c756d 65204469 ….. .Volume Di 0118104a: 73636f75 6e746400 e803051a 18161607 scountd……… Offset 90 – 0118105a: 020201f4 01200043 7573746f 6d657220 ….. .Customer 0118106a: 44697363 6f756e74 38303432 031c1807 Discount8042…. OFFSET TABLE: Row – Offset 2 (0x2) – 90 (0x5a), 1 (0x1) – 58 (0x3a), 0 (0x0) – 32 (0x20), |
See Figure 2:
Figure 2. Discounts data page structure
Continues…