SQL SERVER:DBCC PAGE

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

 

示例:

dbcc traceon(3604)
dbcc page(test,1,10964034,1)

注:首先要开启3604跟踪标志,否则dbcc page命令不会把结果返回到客户端。

posted @ 2022-06-25 17:56  竹楼风雨声  阅读(112)  评论(0编辑  收藏  举报