dbcc log ( [dbid][, objid][, pagenum][, rownum][, nrecords][, type], printopt )
Print log records.
Parameters
ParamDescriptionValid Values
dbid (optional) database ID
objid (optional) object ID
pagenum (optional) page number ORif given with no rownum
transaction ID if rownum is supplied
rownum (optional) transaction ID if given with pagenum
nrecords (optional) number of records to examine If positive, the first
nrecords log entries which meet the criteria (dbid, objid, pagenum,
rownum) are printed in forward order.
If negative, the last nrecords which meet the criteria are printed in
reverse order.
type (optional) type of record to print -1 Print all records
0 XREC_BEGINXACT
1 XREC_CHSYSIND
2 XREC_SWITCHTO
3 XREC_RETURN
4 XREC_INSERT
5XREC_DELETE
6 XREC_INSIND
7XREC_IINSERT
8 XREC_IDELETE
9 XREC_MODIFY
10XREC_NOOP
11 XREC_INOOP
12 XREC_DNOOP
13 XREC_ALLOC
14 XREC_DBNEXTID
15XREC_EXTENT Allocate extents without pages allocated.
16 XREC_SPLIT
17 XREC_CHECKPOINT
18 XREC_SAVEXACT
19 XREC_CMD
20 XREC_DEXTENT Deallocate extents.
21 XREC_DEALLOC Deallocate page.
22 XREC_DROPEXTS Delete all extents on an allocation page.
23 XREC_AEXTENTS Allocate extent and mark all pages used.
24 XREC_SALLOC Allocate for new page of a split.
25 XREC_PGCHGSYSIND Direct change to sysindexes.
27 XREC_SORT
28 XREC_SODEALLOC
29 XREC_ALTDB
30 XREC_ENDXACT
31 XREC_SORTTS
32 XREC_TEXT Direct inserts.
33 XREC_INOOPTEXT Deferred TEXT insert.
34 XREC_DNOOPTEXT Deferred TEXT delete.
35 XREC_ISINDTEXT Indirect insert.
36 XREC_TEXTDELETE Delete text
printopt print option 0 print out header information only (default)
1 print out header and data information.
dbcc logtransfer ('reserve', 'context')
dbcc logtransfer ('scan', {'normal'|'repeat'|'continue'})
Refer to your Rep Server manual.
dbcc memusage
Display detailed information on server's memory usage.
dbcc monitor ( task, group, option )
Allows a more detailed monitoring of the SQL Server. [Hint: Run dbcc
traceon(8399) first, to enable descriptive names for groups.]
Parameters
ParamValuePurpose
task"clear" clear earlier gathered statistics
"sample" gather fresh statistics
"select" enable statistics to be displayed
group "all" all groups' statistics are gathered/displayed
group_name name of the group for which statistics are to be
gathered/displayed
option "on" enable monitoring
"off" discontinue monitoring
dbcc netmemshow ([ option ])
Prints network memory allocations.
Parameters
ParamValuePurpose
option (optional) 1 summary information
2 or 3 all information (default)
dbcc netmemusage
Prints memory usage details.
dbcc newalloc ( dbname, option )
Reports on pages and extents in use.
Parameters
ParamDescription
dbname database name
option 1, 2, or 3
Caveat Emptor!!
Use them at your own risk!
dbcc page ( dbid, pagenum [, printopt ][, cache ][, logical ] )
Prints the contents of the specified page.
Parameters
ParamDescriptionValid Values
dbid database ID
pagenum the logical or virtual page number
printopt (optional) print option 0 print out only the buffer header and
page header (default)
1 print buffer headers, page header, each row separately and the offset
table
2 print out buffer and page headers, page as a whole and the offset table.
cache (optional) handling of pages in cache 0 print out the page as found
on disk
1 print out the page as found in cache if it resides in cache, otherwise
retrieve the page from disk and p
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
