Tuesday, November 20, 2012

DBCC PAGE

This is copied from http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx

dbcc page ( {'dbname' | dbid}, filenum, pagenum [, printopt={0|1|2|3} ])


The printopt parameter has the following meanings:

  • 0 - print just the page header
  • 1 - page header plus per-row hex dumps and a dump of the page slot array (unless its a page that doesn't have one, like allocation bitmaps)
  • 2 - page header plus whole page hex dump
  • 3 - page header plus detailed per-row interpretation

The per-row interpretation work for all page types, including allocation bitmaps.
By default, the output is sent to the errorlog. If you want the output to come back to your current connection, turn on trace flag 3604.

DBCC traceon(3604)
DBCC PAGE (master, 1, 1, 0);

No comments: