dbcc时间太长，我想停止此进程，行不？在线等待！！！

cailiang007

请问各位，我在做SYBASE DBCC时，时间很长了，我想将此DBCC进程停止掉，请问，可否，我记得好象不能停止此进程吧。

chuxu

你加nofix了吗？

1017of

如果没有I/O流量，实在需要可冒险一下，否则..............

trytodoit

应该没有问题，我试过，记得我是头天晚上21：30做的，结果第二天早上都还没有做完，但它又要影响系统性能，所以我把过程给杀了，结果没出现什么不对的

cailiang007

我的ＳＱＬ如下：
use master
go
sp_dboption xlshop,"single user",true
go
use xlshop
go
checkpoint
go
dbcc checkdb(xlshop)
go
dbcc checkalloc(xlshop,fix)
go
dbcc checkcatalog(xlshop)
go
use master
go
sp_dboption xlshop,"single user",false
go
use xlshop
go
checkpoint
go
quit
go
应该没问题的。

cailiang007

我加的可是fix参数，我以前在ＳＵＮ的小机上，一个１０多Ｇ的库，也就不到一晚就完了。而且是手工做的，现在这个库不到10Ｇ咱这么久还不完呢？在查看日志的时候发现，到某一个表时，就不动了。。但服务器硬盘灯一直在闪着。应该是正常的，但就是慢。

cailiang007

以下是我执行语句生成的日志文件内容。到其中dwcol一张表就再没往下走了。
Database option 'single user' turned ON for database 'xlshop'.
Run the CHECKPOINT command in the database that was changed.
(return status = 0)
Checking xlshop
Checking sysobjects
The total number of data pages in this table is 79.
Table has 1136 data rows.
Checking sysindexes
The total number of data pages in this table is 94.
Table has 1125 data rows.
Checking syscolumns
The total number of data pages in this table is 125.
Table has 3869 data rows.
Checking systypes
The total number of data pages in this table is 1.
Table has 28 data rows.
Checking sysprocedures
The total number of data pages in this table is 1676.
Table has 7526 data rows.
Checking syscomments
The total number of data pages in this table is 89.
Table has 861 data rows.
Checking syssegments
The total number of data pages in this table is 1.
Table has 3 data rows.
Checking syslogs
The total number of data pages in this table is 11078.
*** NOTICE:  Space used on the log segment is 21.64 Mbytes, 2.11%.
*** NOTICE:  Space free on the log segment is 1002.36 Mbytes, 97.89%.
Table has 296405 data rows.
Checking sysprotects
The total number of data pages in this table is 1.
Table has 38 data rows.
Checking sysusers
The total number of data pages in this table is 1.
Table has 8 data rows.
Checking sysalternates
The total number of data pages in this table is 1.
Checking sysdepends
The total number of data pages in this table is 2.
Table has 121 data rows.
Checking syskeys
The total number of data pages in this table is 1.
Table has 32 data rows.
Checking sysusermessages
The total number of data pages in this table is 1.
Checking sysreferences
The total number of data pages in this table is 5.
Table has 115 data rows.
Checking sysconstraints
The total number of data pages in this table is 2.
Table has 123 data rows.
Checking systhresholds
The total number of data pages in this table is 1.
Table has 1 data rows.
Checking sysroles
The total number of data pages in this table is 1.
Table has 6 data rows.
Checking sysattributes
The total number of data pages in this table is 1.
Table has 16 data rows.
Checking syspartitions
The total number of data pages in this table is 1.
Checking gdsadd
The total number of data pages in this table is 1.
Checking truindtl
The total number of data pages in this table is 1.
Checking dtapwr
The total number of data pages in this table is 53.
Table has 1863 data rows.
Checking rptcse
The total number of data pages in this table is 1.
Table has 10 data rows.
Checking cyc
The total number of data pages in this table is 1.
Table has 2 data rows.
Checking aasdtl
The total number of data pages in this table is 1.
Table has 13 data rows.
Checking gdsaverageqty
The total number of data pages in this table is 1.
Checking sprcbs
The total number of data pages in this table is 815.
Table has 5924 data rows.
Checking czk
The total number of data pages in this table is 1.
Checking bllitmbk
The total number of data pages in this table is 1.
Checking jwlchgdtl1
The total number of data pages in this table is 1.
Checking abopt
The total number of data pages in this table is 1.
Table has 38 data rows.
Checking gdsblc
The total number of data pages in this table is 1.
Checking dtlsub
The total number of data pages in this table is 1.
Checking rtndtl
The total number of data pages in this table is 1.
Checking bllodw
The total number of data pages in this table is 3.
The total number of TEXT/IMAGE pages in this table is 487.
Table has 28 data rows.
Checking accdtl
The total number of data pages in this table is 1.
Checking rtnrsn
The total number of data pages in this table is 1.
Table has 2 data rows.
Checking czkcz
The total number of data pages in this table is 1.
Checking odrrqt
The total number of data pages in this table is 1.
Checking gdsbs
The total number of data pages in this table is 178888.
Table has 2409994 data rows.
Checking dtrlog
The total number of data pages in this table is 6.
Table has 138 data rows.
Checking bllpdw
The total number of data pages in this table is 2.
The total number of TEXT/IMAGE pages in this table is 436.
Table has 20 data rows.
Checking actbok
The total number of data pages in this table is 1.
Table has 19 data rows.
Checking trumem
The total number of data pages in this table is 1.
Checking salcheck
The total number of data pages in this table is 155.
Table has 2025 data rows.
Checking czkdtl
The total number of data pages in this table is 1.
Table has 13 data rows.
Checking dtropt
The total number of data pages in this table is 1.
Table has 26 data rows.
Checking salcot
The total number of data pages in this table is 1.
Checking odrsche
The total number of data pages in this table is 1.
Checking bokopt
The total number of data pages in this table is 1.
Table has 170 data rows.
Checking jwlchgdtl2
The total number of data pages in this table is 1.
Checking actdwee
The total number of data pages in this table is 58.
Table has 1669 data rows.
Checking dupno
The total number of data pages in this table is 1.
Checking czkopt
The total number of data pages in this table is 1.
Checking bpbs
The total number of data pages in this table is 624.
Table has 8174 data rows.
Checking trusftdtl
The total number of data pages in this table is 1.
Checking sprccls
The total number of data pages in this table is 1.
Table has 10 data rows.
Checking odrschedtl
The total number of data pages in this table is 1.
Checking ldfeeblc
The total number of data pages in this table is 1.
Checking actfee
The total number of data pages in this table is 8.
Table has 207 data rows.
Checking dw
The total number of data pages in this table is 12.
The total number of TEXT/IMAGE pages in this table is 1592.
Table has 118 data rows.
Checking czkrcd
The total number of data pages in this table is 1.
Checking trustlcls
The total number of data pages in this table is 1.
Table has 2 data rows.
Checking sprwgds
The total number of data pages in this table is 1.
Checking salday
The total number of data pages in this table is 1.
Checking lelcod
The total number of data pages in this table is 1.
Checking gdsbuy
The total number of data pages in this table is 43345.
Table has 464280 data rows.
Checking dctrto
The total number of data pages in this table is 1.
Checking bqut
The total number of data pages in this table is 1.
Checking actitm
The total number of data pages in this table is 1.
Checking spstlge
The total number of data pages in this table is 1.
Checking salmonth
The total number of data pages in this table is 1.
Checking odrtreaty
The total number of data pages in this table is 1.
Checking tsidtl
The total number of data pages in this table is 1.
Checking dwcol
The total number of data pages in this table is 57.

小无赖

dwcol表大概有多大,怎么会这么慢呢,会不会是表有问题.

cailiang007

关键现在，我又把用户库置为单用户状态了。业务系统不能运行。如果能中断掉。又不影响系统。就好了。