Data Page Structures in SQL Server 6.5

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…

Pages: 1 2 3




Array

No comments yet... Be the first to leave a reply!