sql server未经确认的dbcc命令
相关英文：（2000和7中支持的dbcc命令）http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm
http://www.windowsitlibrary.com/Content/77/21/1.html
下面这些dbcccommand有些是没有官方支持的，不建议初学者使用。切记小心使用，不过有很多还是非常有用，有兴趣的可以测试看看！ （这些命令似乎在sql server6.5中可用）
Unauthorized
ofSybaseDBCCCommands
<script type="text/javascript"><!-- google_ad_client = "pub-1572879403720716"; google_ad_width = 336; google_ad_height = 280; google_ad_format = "336x280_as"; google_ad_type = "text_image"; google_ad_channel ="6686853775"; google_alternate_ad_url ="http://www.qqread.com/0000js/google336.htm"; google_color_border = "EDF0F5"; google_color_bg = "EDF0F5"; google_color_link = "0000FF"; google_color_url = "008000"; google_color_text = "000000"; //--></script><script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script><iframe width="336" scrolling="no" height="280" frameborder="0" allowtransparency="true" hspace="0" vspace="0" marginheight="0" marginwidth="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-1572879403720716&dt=1167381268140&lmt=1157009408&alternate_ad_url=http%3A%2F%2Fwww.qqread.com%2F0000js%2Fgoogle336.htm&prev_fmts=468x15_0ads_al_s&format=336x280_as&output=html&channel=6686853775&url=http%3A%2F%2Fwww.qqread.com%2Fsybase%2Fc108125052.html&color_bg=EDF0F5&color_text=000000&color_link=0000FF&color_url=008000&color_border=EDF0F5&ad_type=text_image&ref=http%3A%2F%2Fsearch.cn.yahoo.com%2Fsearch%3Flp%3DDBCC%2Blog%2B%2528%2527rsxx%2527%252C%2B2%2529%26p%3DDBCC%2Blog%26ei%3DUTF-8%26pid%3Dysearch%26meta%3D&cc=2&u_h=768&u_w=1024&u_ah=734&u_aw=1024&u_cd=32&u_tz=480&u_his=1&u_java=true&u_nplug=14&u_nmime=72" name="google_ads_frame"></iframe>
Usethematyourownrisk!
dbccallocdump(dbid,page)
Displaysallextentsonanallocationpage.
Parameters
dbiddatabaseID
pageallocationpagenumber
dbccallocmap(dbid,one_all,allocpg,bit_stat)
Displayormodifystatusofallocationbitmapsusedtodetectfullallocation
pages.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
one_allbitmap(s)tocheck/modify0entireallocationmap
1singleallocationmap
allocpgallocationpage,ifone_all=1
bit_statstatusofthebits0checkthestatus
1setthebit(s)
2clearthebit(s)
dbccbhash(print,bucket_limit)
Checkintegrityofandoptionallyprintthebufferhashtable.
Parameters
ParamDescriptionValidValues
printprintoptionprint_bufsdisplayallbuffers(default)
no_printdisplayonlybufferswithproblems
bucket_limitnumberofbuffersallowedinabucket.default=0
dbccbufcount(n_chains)
Printupto10longestbufferchainsandaveragechainlength.
Parameters
ParamDescriptionValidValues
n_chainsthenumberofchainstoprint1-10
dbccbuffer([,objid][,nbufs],printopt,buftype)
Printsbufferheadersandpagesfromthebuffercache.
Parameters
ParamDescriptionValidValues
dbid(optional)databasenameordatabaseID0willshowdataforall
databases.
objid(optional)objectID0willshowdataforallobjects.
nbufs(optional)numberofbufferstoexamine.Ifpositive,thenbufs
bufferswhichmeettheothercriteria(dbid,objid)areprintedinMRUto
LRUorder.Ifnegative,thelastnbufsbufferswhichmeetthecriteriaare
printedinLRUtoMRUorder.If0,allbufferswillbeprintedinMRUto
LRUorder.
printoptprintoption0printoutonlythebufferheaderandpageheader
(default)
1printouteachrowseparatelyandtheoffsettable
2printouteachrowasawholeandtheoffsettable
buftypebuffertypetoprintCanbenumericorasymboliccharacter
string.Seetablebelowforpossiblestringsandtheirhexadecimal
equivalents
BufferTypes
ParamHexDescription
BUF_DIRTY1Bufferincachediffersfromdiskimage.
BUF_IO2Bufferisbeingreadorwritten.
BUF_PINNED4Thelogmustbewrittenbeforethisbufferis.
BUF_KEPT8Someprocessisusingthisbuffer.
BUF_RLOCK10Thebufferisresourcelocked.
BUF_TRIP20Thebufferagesoutofcachemoreslowly.
BUF_NEW40Buffercontainsanewpageandhasneverbeenwritten.
BUF_RWAIT80Theprocessiswaitingforrlock.
BUF_IOERR100Therewasanerrorwritingtisbuffer.
BUF_SPECIAL200Ifthisbufferiswritten,updaterelevantdescriptors.
BUF_WQUEUE400Thisbufferisqueuedforanout-of-sequencedatabasedump.
BUF_NOTHASHED800Thisbufferisnothashed.
BUF_HASHED1000Thisbufferishashed.
BUF_DIAG2000Thisisaspecialbufferusedfordiagnosticsonly.
BUF_FILTHY4000ThebufferwasdirtiedwhileinI/O(logonly).
BUF_NORELEASE8000Thisisusedforcoordinatingreleasesofrlockson
allocationpages.
dbccbytes(startaddress,length)
Dumpoutbytesfromspecificaddress.
Parameters
ParamDescription
startaddressstartingaddresstodump
lengthnumberofbytestodump
dbcccacheremove(dbname,objectname)
Removesobjectfromcache.
Parameters
ParamDescription
dbnamedatabasename
objnameobjectname
dbcccapture_tds(spid)
CapturesTabularDataStreamintoafilecalled$SYBASE/install/TDSDUMP.File
containsfullstream,includingpasswords--chmodthefiletoprotectthis
information.
dbcccheckalloc[(dbname[,option])]
Checkdataandindexpagesagainstcorrespondingextentstructures(earlier
newalloc).
Parameters
ParamDescriptionValidValues
dbname(optional)databasename
option(optional)fixoptionfixreportandfixdescrepancies
nofixreportdecrepanciesonly(default)
dbcccheckcatalog[(dbname)]
Checkconsistencyofsystemcatalogstablesfordatabasenamed.
Parameters
ParamDescription
dbname(optional)databasename;defaultiscurrentdb
dbcccheckdb[(dbname[,skip_ncindex])]
Checkconsistencyofdataandindexpages.
Parameters
ParamDescription
dbname(optional)databasename;defaultiscurrentdb
skip_ncindex(optional)skipcheckonnonclusteredindexesforthe
database
dbccchecktable(tabid[,skip_ncindex])
Checkconsistencyofdataandindexpages.
Parameters
ParamDescription
tabidtablenameortableID
skip_ncindex(optional)skipcheckonnonclusteredindexesforthetable.
dbccchgdbname(dbname,newname)
ChangesdatabasenameinDBINFOonly.
Parameters
ParamDescription
dbnameexistingdatabasename
newnamenewdatabasename
dbccchgobjname(objname,newname)
Changesobjectnameincacheonly.
Parameters
ParamDescription
objnameexistingobjectname
newnamenewobjectname
dbcccursorinfo(cursor_level,cursor_name)
Displayscursorinformation.
Parameters
ParamDescription
cursor_levellevelnumber;-1togetcursorinfoforallnestinglevels
cursor_namenameofthecursor
dbccdbinfo[(dbname)]
PrintDBINFOstructureforspecifieddatabase.
Parameters
ParamDescription
dbname(optional)databasename
dbccdbrecover(dbname)
Thiswillhaverecoveryrunonasuspectdatabasewithoutrebootingtheserver.
Parameters
ParamDescription
dbnamedatabasename
dbccdbrepair(db,option[,table][,index])
Repairsystemtables.
Parameters
ParamDescriptionValidValues
dbdatabaseIDordatabasename
optionrepairoptiondropdbdropthespecifieddatabase
findstrandeddisplaystrandedobjects
fixindexrebuildthespecifiedindex;usedonsystemcatalogsonly
fixsysindexcorrectpfreeoffvalueforsysindexes
newthresholdrebuildthedatabasethresholdtable
remapupdatethein-coreimageofthedatabaseusagemaptable
repairindexrepairindexforusertables
table(optional)tablename
index(optional)indexID
dbccdbtable(dbid)
PrintoutthecontentsoftheDBTABLEstructure.
Parameters
ParamDescription
dbiddatabaseID
dbccdelbuff(dbid,page,dirty_flush,kept_flag,rlock_flag)
Removebufferfromcache,optionallyflushtodisk.
Parameters
ParamDescription
dbiddatabaseID
pagethelogicalpagenumberofthepagetoberemoved
dirty_flushif1,thenflushthepagetodiskifDIRTY
kept_flagif1,thendonotunkeepbufferifKEPT
rlock_flagif1,thendonotremoveRESOURCELOCK
dbccdelete_row(dbid,page,delete_by_row,rownum)
Deleteanindexordatarowbyeitherarownumberoranoffsetonapage.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
pagethelogicalpagenumber
delete_by_rowdeletelocation;byroworbyoffset1nextparameteris
interpretedasrownumber
0nextparameterisinterpretedasoffsetonthepage
rownumeitherarownumberoroffset
dbccdes[([,objid])]
PrintsthecontentsofthespecifiedDES(descriptor).
Parameters
ParamDescription
dbid(optional)databaseID
objid(optional)objectID
dbccdescount(n_chains)
Printupto10longestDESchains.P>Parameters
ParamDescription
n_chainsthenumberofchainstoprint,upto10.
dbccdesdiag(dbid,option)
ProduceDESdiagnosticreports.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
optiondiagnostictorun-4DisplayHashTableGraph
-3DisplayDiagnosticMaps
-2Runallthetests(1-4)
-1Returntocaller-Exit
0Redisplaythismenu
1CheckFreeDesChain
2CheckDbtableDESchain
3CheckDesKept/Unkeptchain
4CheckDesName/Idhashtable
5Display'lost'descriptors
6Runtests(1-4),kepaniconerrors
dbccengine(engine,func)
Parameters
ParamDescription
engineenginenumber
func"online"
"offline"
dbccextentchain(dbid,objid,indexid,sort,display,[,order])
Displaysorcountsextentsfollowingthechain,checkingchainintegrity.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
sortreportonstateofthesortbit0don'tincludethisinfo
1doreportonsortbitstatus
displaywhattoreport0displaythecountonly
1displaytheextents
order(optional)ordertofollowthechain0descending
1ascending
dbccextentcheck(dbid,objid,indexid,sort)
Examineallextentsonallocationpagesforspecifiedobject.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
stateofthesortbit0don'treportthis
1reportsortbitstatus
dbccextentdump(dbid,page)
Displayanextent.
Parameters
ParamDescription
dbiddatabaseID
pagethenumberofapagecontrolledbytheextentinquestion
dbccextentzap(dbid,objid,indexid,sort)
Clearallextentsmatchingtheparametervalues.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
sortstateofthesortbit0
1
dbccfindnotfullextents(dbid,objid,indexid,sort)
Findallnotfullextentsonallallocationpagesforthespecifiedobject.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
sortstateofthesortbit0
1
dbccfix_al[(dbname)]
Makeallocationbitmapsmatchthepagechains.
Parameters
ParamDescription
dbname(optional)databasename
dbccfix_text(table)
Toupgradetextvaluesafterconvertingtheservertoamulti-bytecharacter
set.
Parameters
ParamDescription
tabletablenameortableID
dbccgettrunc()
ReplicationServerrelated:PrintscurrentLTM(LogTransferManager)
informationforthedatabase.
dbcchelp(dbcc_command)
Givesyntaxonspecificdbcccommand.
Parameters
ParamDescription
dbcc_commandthecommandforwhichsyntaxhelpisdesired
dbccind(dbid,objid,printopt)
Printeachindexpageforaspecifiedtable.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
printoptprintoption0printoutonlythebufferheaderandpageheader
(default)
1printpageheaders,pagedatainrowformat,andoffsettables
2printpageheaders,unformattedpagedata,andoffsettables
dbccindexalloc(table,indid[,report][,fix])
Parameters
ParamDescriptionValidValues
tabletablenameortableID
indidindexID
report(optional)reportstylefullcompletedetails
optimizedessentialdetails(default)
fastquickreport
fix(optional)fixflagfixfixallocationerrorsontraversal(default)
nofixdonotfixallocationerrors
dbccis_replication_enabled
ReturnsTrue/Falsevia@@errorvalue.Immediatelyafterrunningthiscommand,
select@@error.If@@error=0,replicationisenabled,elsereplicationisnot
enabled.
dbcclistoam(db,objid,indid)
Listsobjectallocationinformation.
Parameters
ParamDescription
dbdatabaseIDordatabasename
objidobjectID
indid(optional)indexID
dbcclocateindexpgs(dbid,objid,page,indexid,level)
Printallreferencesintheindextothespecifiedpage.
Parameters
ParamDescription
dbiddatabaseID
objidobjectID
pagelogicalpagenumberofthepageforwhichindexreferencesarebeing
searched
indexidindexID
levellevelwithintheindextosearchforreferences
dbcclock
Printoutlockchains.
dbcclockunit(file_name)
Parameters
ParamDescription
file_namefilein$SYBASE/install
dbcclog([,objid][,pagenum][,rownum][,nrecords][,type],printopt)
Printlogrecords.
Parameters
ParamDescriptionValidValues
dbid(optional)databaseID
objid(optional)objectID
pagenum(optional)pagenumberORifgivenwithnorownum
transactionIDifrownumissupplied
rownum(optional)transactionIDifgivenwithpagenum
nrecords(optional)numberofrecordstoexamineIfpositive,thefirst
nrecordslogentrieswhichmeetthecriteria(dbid,objid,pagenum,
rownum)areprintedinforwardorder.
Ifnegative,thelastnrecordswhichmeetthecriteriaareprintedin
reverseorder.
type(optional)typeofrecordtoprint-1Printallrecords
0XREC_BEGINXACT
1XREC_CHSYSIND
2XREC_SWITCHTO
3XREC_RETURN
4XREC_INSERT
5XREC_DELETE
6XREC_INSIND
7XREC_IINSERT
8XREC_IDELETE
9XREC_MODIFY
10XREC_NOOP
11XREC_INOOP
12XREC_DNOOP
13XREC_ALLOC
14XREC_DBNEXTID
15XREC_EXTENTAllocateextentswithoutpagesallocated.
16XREC_SPLIT
17XREC_CHECKPOINT
18XREC_SAVEXACT
19XREC_CMD
20XREC_DEXTENTDeallocateextents.
21XREC_DEALLOCDeallocatepage.
22XREC_DROPEXTSDeleteallextentsonanallocationpage.
23XREC_AEXTENTSAllocateextentandmarkallpagesused.
24XREC_SALLOCAllocatefornewpageofasplit.
25XREC_PGCHGSYSINDDirectchangetosysindexes.
27XREC_SORT
28XREC_SODEALLOC
29XREC_ALTDB
30XREC_ENDXACT
31XREC_SORTTS
32XREC_TEXTDirectinserts.
33XREC_INOOPTEXTDeferredTEXTinsert.
34XREC_DNOOPTEXTDeferredTEXTdelete.
35XREC_ISINDTEXTIndirectinsert.
36XREC_TEXTDELETEDeletetext
printoptprintoption0printoutheaderinformationonly(default)
1printoutheaderanddatainformation.
dbcclogtransfer('reserve','context')
dbcclogtransfer('scan',{'normal'|'repeat'|'continue'})
RefertoyourRepServermanual.
dbccmemusage
Displaydetailedinformationonserver'smemoryusage.
dbccmonitor(task,group,option)
AllowsamoredetailedmonitoringoftheSQLServer.[Hint:Rundbcc
traceon(8399)first,toenabledescriptivenamesforgroups.]
Parameters
ParamValuePurpose
task"clear"clearearliergatheredstatistics
"sample"gatherfreshstatistics
"select"enablestatisticstobedisplayed
group"all"allgroups'statisticsaregathered/displayed
group_namenameofthegroupforwhichstatisticsaretobe
gathered/displayed
option"on"enablemonitoring
"off"discontinuemonitoring
dbccnetmemshow()
Printsnetworkmemoryallocations.
Parameters
ParamValuePurpose
option(optional)1summaryinformation
2or3allinformation(default)
dbccnetmemusage
Printsmemoryusagedetails.
dbccnewalloc(dbname,option)
Reportsonpagesandextentsinuse.
Parameters
ParamDescription
dbnamedatabasename
option1,2,or3
CaveatEmptor!!
Usethematyourownrisk!
dbccpage(dbid,pagenum[,printopt][,cache][,logical])
Printsthecontentsofthespecifiedpage.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
pagenumthelogicalorvirtualpagenumber
printopt(optional)printoption0printoutonlythebufferheaderand
pageheader(default)
1printbufferheaders,pageheader,eachrowseparatelyandtheoffset
table
2printoutbufferandpageheaders,pageasawholeandtheoffsettable.
cache(optional)handlingofpagesincache0printoutthepageasfound
ondisk
1printoutthepageasfoundincacheifitresidesincache,otherwise
retrievethepagefromdiskandprint(default).
logical(optional)typeofpage0pagenumistakentoavirtualpage
number
1pagenumistakentobealogicalpagenumber(default)
dbccpglinkage(dbid,start,number,printopt,target,order)
Displaythepagechain,performingintegritychecksduringtraversal.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
startpagenumberwithwhichtostart
numbernumberofpagestoexamine,or0iftargetisspecified
printoptprintoption0displayonlythecountofpagesscanned
1displayinformationaboutthelast16pagesscanned
2displayallpagenumbersinthescan
targettheparticularpagewearelookingfor,or0ifnumberisspecified
Specifyingatargetwillcontinuetosearchinthespecifieddirection
untilthetargetpageortheendofthechainisfound.
ordertraversalorder0descending
1ascending
dbccpktmemshow()
Listsnetworkbuffersforactiveprocesses.
Parameters
ParamDescription
spid(optional)serverprocessID
dbccprocbuf([,objid][,nbufs][,printopt])
Printprocedurebufferheadersandproc-headersfromtheprocedurecache.
Parameters
ParamDescriptionValidValues
dbid(optional)databaseID
objid(optional)objectID
nbufs(optional)numberofbufferstoprint
printopt(optional)printoption0printoutonlytheprocbuffandproc
header(default)
1printoutprocbuff,procheaderandcontentsofbuffer.
dbccprocdiag(dbid,option)
Producediagnosticsonprocedurebuffers
Parameters
ParamDescriptionValidValues
dbiddatabaseID
optiondiagnostictorun0displayoptionmenu
1displaydiagbitmaps
2displayprocbufsincache
3runsummarydiagnosticsonentirecache
dbccprtipage(dbid,objid,indexid,indexpage)
Printthepagenumberpointedtobyeachrowonthespecifiedindexpage.
Parameters
ParamDescription
dbiddatabaseID
objidobjectID
indexidindexID
indexpagethelogicalpagenumberoftheindexpagetodump
dbccpss(suid,spid,printopt)
PrintsthecontentsofthespecifiedPSSstructure.
Parameters
ParamDescriptionValidValues
suid(optional)serveruserID
spid(optional)serverprocessID
printoptprintoption0standardoutput
1allopenDES'sandcurrentsequencetree
2printalllocksheldbytheprocesstotheerrorlog.
dbccrebuild_log(dbname,rebuild,all)
Generatesanewlogcontainingasinglecheckpointrecord.
Parameters
ParamDescriptionValidValues
dbnamedatabasename
rebuildrebuildlogflag0donotcreateanewlog
1createanewlog
allremovelogflag0oldpreservedlogremoved
1oldpreservedandnewlogremoved
dbccrebuildextents(dbid,objid,indexid,sort,override)
Rebuildanobject'sextentchain.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
indexidindexID
sortstateofthesortbit0sorted
1notsorted
overrideoverrideoption0rebuildonlyifdatabaseisnotopen
1rebuildeventhoughdatabaseisalreadyopen
dbccreindex(tablename)
Rebuildsindexes.
Parameters
ParamDescription
tablenametablewhoseindexesaretoberebuilt
dbccremap(objid,dbname,1)
Remapsastoredproc,trigger,rule,default,orviewtobecompatiblewith
release10.0.
Parameters
ParamDescription
objidobjectID
dbnamedatabasename
dbccreport_al[(dbname)]
Reportondifferencesbetweenallocationbitmapsandpagechains.
Parameters
ParamDescription
dbname(optional)databasename
dbccresource
PrintouttheRESOURCEstructure.
dbccsave_rebuild_log(dbname)
Generateanewlogcontainingasinglecheckpointrecordandpreserveoldlog
extentsbychangingtheobjectID.
Parameters
ParamDescription
dbnamedatabasename
dbccsetkeepalive(#minutes)
ForuseonNovellTCP/IPonly.
dbccsetreplicate(replicate_name,dbccbit)
Updatethereplicationstatusoftheobjectincacheonly.
Parameters
ParamDescriptionValidValues
replicate_nameobjectname
dbccbitnewstatus0false
1true
dbccsettrunc("ltm",option[,generation_num])
ReplicationServerrelated:modifiesLTM(LogTransferManager)informationfor
thedatabase."ltm"isenteredasaliteralstring.
Options
OptionDescriptionValidValues
truncationoptionShouldlogbeallowedtobetruncated.Canbeeither:
"valid"setlogtruncationoff--Theservercannottruncatetranlog
recordsthathavenotbeentransferredtoRepServeryet.
"ignore"allowlogtobetruncated(viadumptranwithno_log,etc.)
generationidoptionresetsthedatabasegenerationnumberto
generation_num.Usedtoincrementnumberafteradumprestoretoprevent
RepServerfromrejectingtransactionsasduplicates"gen_id",
generation_num
dbccshow_bucket(dbid,page,lookup_type)
Lookforspecifiedpageinthebuffercache.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
pagelogicalpagenumberofpagebeinglookedfor
lookup_typehowtoconductsearch1usehashalgorithmtolookinthe
bucketthepageshouldbein
2scantheentirebuffercache
dbccshowtext(db,page)
Displaystextorimagedatacontainedonaspecifiedpage.
Parameters
ParamDescription
dbdatabasenameordatabaseID
pagelogicalpagenumber
dbcctab(dbid,objid,printopt)
Printsoutthecontentsofeachdatapageforthegiventable.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
objidobjectID
printoptprintoption0printoutonlythepageheader(default)
1printouteachrowseparatelyandtheoffsettable
2printoutthepageasawholeandoffsettable
dbcctablealloc(tablename[,option][,mode])
Checkdataandindexpagesagainstcorrespondingextentstructuresforatable.
Parameters
ParamDescriptionValidValues
tablenametablenameortableID
option(optional)cantakethefollowingfullfullycheckallocation
optimizedcheckallocationpageslistedinOAM(default)
fastexceptionreportreferencedbutnotallocated
nullasoptimized
mode(optional)cantakethefollowingfixfixerrorsontraversal
(defaultforusertables)
nofixdonotfixerrors(defaultforsystemtables)
dbccthresholds(db)
Providesthresholdsinformationonthedatabase.
Parameters
ParamDescription
dbdatabasenameordatabaseID
dbcctraceoff(tracenum[,tracenum]...)
Turnoffspecifiedtraceflags.
Parameters
ParamDescription
tracenumnumberofthetraceflagtoturnoff
dbcctraceon(tracenum[,tracenum]...)
Turnonspecifiedtraceflags.
Parameters
ParamDescription
tracenumnumberofthetraceflagtoturnon
Traceflagscanbethefollowing:
TraceFlags
NumberDescription
200"Before"imageofquerytree
201"After"imageofquerytree
260Toprevent"done_in_proc"messages
302Informationinindexselection
310Informationinjoinselection
317Completeinformationinjoinselection(voluminous)
320Turnoffjoinorderheuristic
1204Printoutdeadlockchainsandvictim
1205Printoutstacktracesofdeadlockedpids.Useinconjuctionwith
1204
2512Bypasssyslogswhendoingcheckalloc
1603UseonlystandardunixcallsfordiskI/O
1610Disablepacketbatching
3300Displayeachlogrecordasitisprocessedbyrecovery(voluminous)
3402Doaallocupgradeduringloaddbrecovery
3604Senddbccoutputtoscreen
3605Senddbccoutputtoerrorlog
3607Donotrecoveranydatabase,cleartempdb,orstartupcheckpoint
3608Recovermasteronly.Donotcleartempdb,orstartupcheckpoint
3609Recoveralldatabases.Donotcleartempdb,orstartupcheckpoint
3620Donotkillinfectedprocesses
3701Allowsdroppingandcreatingofsystemindexes(DANGEROUS!)
4000Crashserveratnextloopforrecoverytesting
4012Bootwithoutstartingupcheckpointprocess
4013Placearecordintoerrorlogeachtimesomeonelogsintotheserver
5101Engine0willperformalldiskandnetworkI/O.
5102Preventsengine0fromrunninganynon-affinitiedtasks
8399Enabledescriptivenamesforgroups(dbccmonitor)
dbcctune("parameter",value[,tablename])
Setsbuildmasterparameters.ProbablynotnecessaryasofSystem11,wherethe
oldbuildmasterparametersarenowincorporatedintosysconfigures(see
documentationonsp_configure).
dbccundo(dbid,pgnum,rownum)
dbccupdate_tmode(procname,tranmode)
Updatetransaction-modeinbothsysobjectsandDESforstoredprocedures.
Parameters
ParamDescriptionValidValues
procnamestoredprocedurename
tranmodetransactionmodeunchained
chained
anymode
dbccusedextents(dbid,devtype,display)
Countordisplaythestatusofused/unusedextentsonspecifieddevices.
Parameters
ParamDescriptionValidValues
dbiddatabaseID
devtypetypeofdevicetocheckallshowallextents
logshowextentsofallocationforthelog
nonlogshowextentsofnonlogallocations
displaywhattoreporton0informationabouttheextents
1countoftheextents
页:
[1]