SYBASE dbcc
时间:2007-11-09 来源:不详 作者:迈克DB
usedbccdb
sp_dbcc_updateconfigaca_db,"maxworkerprocesses","2"
sp_dbcc_updateconfigaca_db,"dbccnamedcache",aca_cache,"3072"
sp_dbcc_updateconfigaca_db,"scanworkspace",scan_aca
sp_dbcc_updateconfigaca_db,"textworkspace",text_aca
sp_dbcc_updateconfigaca_db,"OAMcountthreshold","5"
sp_dbcc_updateconfigaca_db,"IOerrorabort","3"
sp_dbcc_updateconfigaca_db,"linkageerrorabort","8"
11、检查aca_db数据库
dbcccheckstorage(aca_db)
执行结果为：
Checkingaca_dbServerMessage:Number9954,Severity10
Line1:
Storagechecksfor'aca_db'arecomplete.DBCCisnowrecordingtheresultsinthedbccdbdatabase.
ServerMessage:Number9974,Severity10
Line1:
DBCCCHECKSTORAGEfordatabase'aca_db'sequence1completedatMay30200010:01AM.0faultsand0suspectconditionswerelocated.0checkswereaborted.Youshouldinvestigatetherecordedfaults,andplanacourseofactionthatwillcorrectthem.
11、dbccdb生成报告
Øsp_dbcc_summaryreport在指定的日期或该日期之前为指定的数据库完成的所有dbcccheckstorage操作
织梦内容管理系统
示例：
sp_dbcc_summaryreport
DBCCOperation:checkstorage
(1rowaffected)
(returnstatus=0)
DatabaseNameStarttimeEndTimeOperationIDHardFaultsSoftFaultsTextColumnsAbortCountUserName
-------------------------------------------------------------------------------------------------aca_db05/30/200010:01:3610:1:50:50310000sa
Øsp_dbcc_configreport为目标数据库生成配置信息的报告。
示例：
sp_dbcc_configreport
Reportingconfigurationinformationofdatabaseaca_db.
ParameterNameValueSize
databasenameaca_db20480K
dbccnamedcacheaca_cache3072K
textworkspacetext_aca(id=544004969)80K
scanworkspacescan_aca(id=512004855)272K
OAMcountthreshold5%
IOerrorabort3
linkageerrorabort8
maxworkerprocesses2
operationsequencenumber1
(1rowaffected)
(returnstatus=0)
Øsp_dbcc_statisticsreport产生从dbcc_counter表中得到的统计信息
示例：
sp_dbcc_statisticsreport"aca_db","auths"
结果：
ParameterNameIndexIdValue
织梦内容管理系统
---------------------------
count020.0
maxsize088.0
maxcount020.0
bytesdata01321.0
bytesused01599.0
count11.0
maxcount11.0
maxlevel10.0
maxsize111.0
bytesdata16.0
bytesused143.0
count2550.0
maxsize2550.0
maxcount2550.0
bytesdata2550.0
bytesused2550.0
ParameterNameIndexIdPartitionValueDev_name
--------------------------------------------
pagegaps011.0disk1
pagesused012.0disk1
extentsused011.0disk1
overflowpages010.0disk1
pagesoverhead011.0disk1
pagesreserved016.0disk1
pageextentgaps010.0disk1
wsbuffercrosses010.0disk1
pageextentcrosses010.0disk1
pagegaps111.0disk1
pagesused112.0disk1
extentsused111.0disk1
overflowpages110.0disk1
pagesoverhead111.0disk1
pagesreserved116.0disk1
pageextentgaps110.0disk1
wsbuffercrosses110.0disk1
pageextentcrosses110.0disk1
pagegaps25511.0disk1
pagesused25512.0disk1
extentsused25511.0disk1
overflowpages25510.0disk1
pagesoverhead25511.0disk1
pagesreserved25516.0disk1
文章评论
共有位Admini5网友发表了评论 查看完整内容