Technical Article

Database Console Command : DBCC page undocumented

,

DBCC page was decommissioned in 7.0 according BOL. Parameters have being changed, but the call itself remains. Following script shows some reverse engineering results.

--Displays a trace of the output of the DBCC command
dbcc traceon (3604)

--The parameters to this DBCC command are:
--DatabaseName
--FileNumber
--PageNumber
--Formatting
-- not set: header only
-- 0 default, header only
-- 1 header, data: slots in hex
-- 2 header, data: Memory Dump in hex
-- 3 header, and additional info , 
--   database header can be taken this way
-- >=4 header (default)

--examples
DBCC PAGE('master',1,1,0)
DBCC PAGE('master',1,1,1)
DBCC PAGE('master',1,1,2)

-- look at some pages in system catalog 
-- or any other database
-- applicable for following versions: 7.X, 2000, 2005

DBCC PAGE('master',1,1,3) -- Page Alloc Status
DBCC PAGE('master',1,2,3) --GAM
DBCC PAGE('master',1,3,3) --SGAM
DBCC PAGE('master',1,4,3) -- 000:header, 2005 - empty
DBCC PAGE('master',1,4,2) --2005 empty
DBCC PAGE('master',1,5,3) --2000:header, 2005 - empty
DBCC PAGE('master',1,5,2) --2005 empty
DBCC PAGE('master',1,6,3) --DCM or Differential Change 
                          -- Map : DIFF_MAP, usefull to 
                          -- predict the size 
                          -- of differential backups
DBCC PAGE('master',1,7,3) --ML_MAP
DBCC PAGE('master',1,8,3) -- slots, same as ('master',1,8,1)
DBCC PAGE('master',1,9,3) -- 2000, 2005: DBINFO
DBCC PAGE('master',1,10,3) -- 2000, 2005: DS_CONFIG
DBCC PAGE('master',1,12,3) -- 2000,2005: IAM, Extent Alloc
DBCC PAGE('master',1,13,3) -- 2000,2005: IAM, Extent Alloc

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating