4 Check Des Name/Id hash table
5 Display 'lost' descriptors
6 Run tests (1-4), kepanic on errors
dbcc engine (engine, func)
Parameters
ParamDescription
engine engine number
func "online"
"offline"
dbcc extentchain ( dbid, objid, indexid, sort, display, [, order ] )
Displays or counts extents following the chain, checking chain integrity.
Parameters
ParamDescriptionValid Values
dbid database ID
objid object ID
indexid index ID
sort report on state of the sort bit 0 don't include this info
1 do report on sort bit status
display what to report 0 display the count only
1 display the extents
order (optional) order to follow the chain 0 descending
1 ascending
dbcc extentcheck ( dbid, objid, indexid, sort )
Examine all extents on allocation pages for specified object.
Parameters
ParamDescriptionValid Values
dbid database ID
objid object ID
indexid index ID
state of the sort bit0 don't report this
1 report sort bit status
dbcc extentdump ( dbid, page )
Display an extent.
Parameters
ParamDescription
dbid database ID
page the number of a page controlled by the extent in question
dbcc extentzap ( dbid, objid, indexid, sort )
Clear all extents matching the parameter values.
Parameters
ParamDescriptionValid Values
dbid database ID
objid object ID
indexid index ID
sortstate of the sort bit 0
1
dbcc findnotfullextents ( dbid, objid, indexid, sort )
Find all not full extents on all allocation pages for the specified object.
Parameters
ParamDescriptionValid Values
dbid database ID
objid object ID
indexid index ID
sortstate of the sort bit 0
1
dbcc fix_al [( dbname )]
Make allocation bitmaps match the page chains.
Parameters
ParamDescription
dbname (optional) database name
dbcc fix_text ( table )
To upgrade text values after converting the server to a multi-byte character
set.
Parameters
ParamDescription
table table name or table ID
dbcc gettrunc ()
Replication Server related: Prints current LTM (Log Transfer Manager)
information for the database.
dbcc help ( dbcc_command )
Give syntax on specific dbcc command.
Parameters
ParamDescription
dbcc_command the command for which syntax help is desired
dbcc ind ( dbid, objid, printopt )
Print each index page for a specified table.
Parameters
ParamDescriptionValid Values
dbid database ID
objid object ID
printopt print option 0 print out only the buffer header and page header
(default)
1 print page headers, page data in row format, and offset tables
2 print page headers, unformatted page data, and offset tables
dbcc indexalloc ( table, indid [, report][, fix] )
Parameters
ParamDescriptionValid Values
table table name or table ID
indid index ID
report (optional) report style full complete details
optimized essential details (default)
fast quick report
fix (optional) fix flag fix fix allocation errors on traversal (default)
nofix do not fix allocation errors
dbcc is_replication_enabled
Returns True/False via @@error value. Immediately after running this command,
select @@error. If @@error = 0, replication is enabled, else replication is not
enabled.
dbcc listoam ( db, objid, indid )
Lists object allocation information.
Parameters
ParamDescription
db database ID or database name
objid object ID
indid (optional) index ID
dbcc locateindexpgs ( dbid, objid, page, indexid, level )
Print all references in the index to the specified page.
Parameters
ParamDescription
dbid database ID
objid object ID
page logical page number of the page for which index references are being
searched
indexid index ID
&nb上一页 [1] [2] [3] [4] [5] [6] [7] 下一页 |
