checktable taking over 8 hrs for one table of 5 million rows

[arlram]

our dbcc's are timing out.. running checktable on datarow locking table with 5 million rows and checktable is not finishing below 8 hrs..any ideas why it takes so long?

 

[sybaseguru]

It could be a number of things. Can you please verify the following
1) sybase version
2) total or max sybase memory
3) Are you using "dbccdb" database. In that case is it configured with enough resources and worker processes?
4) Is this table busy when you are running dbcc on it? For example your batch processes at night are accessing the table.
4) any other info you may find relevant!

 

[markmar1]

Are you using large data cache sizes?? 16K IO??

 

[arlram]

sybaseguru.. thanks for responding.. i missed it last time i was logged in here is the info

ASE 12.0.0.4 EBF 9972
total memory is 3.5 GB
yes using dbccdb.. has recommended resources from evaluatedb
it has 11 worker processes
- it's running on a Sunday.. nothing else runs then.. i moved it there because it was running into our trading day..

thanks again

 

[arlram]

markmar1..

dbcccache is at 200 MB and yes i have 16K io defined...

 

[Tison]

I heard that Sybase v12.0 had a paging problem.
Think about upgrading to 12.5

 

[sybaseguru]

apologies I cam back to this today. If you are still seeing this problem do a sp_help and sp_spaceused on this table and send it please. In addition can you also do a sp_plan_dbccdb on your server and send it as well.

 

[arlram]

sybaseguru.. thanks!!! is there a email i can send the output to.. sp_help is kind of big...

here is sp_spaceused:

name rowtotal reserved data
index_size unused
-------------------- ----------- --------------- ---------------
--------------- ---------------
nms_pl_hist 4589211 4960698 KB 4589246 KB
371066 KB 386 KB

(1 row affected)
(return status = 0)
sp_plan_dbccdb
2> go

Recommended size for dbccdb database is 1621MB (data = 1619MB, log = 2MB).

dbccdb database already exists with size 2400MB.

Recommended values for workspace size, cache size and process count are:

dbname scan ws text ws cache process count


master 1232K 320K 640K 1
tempdb 36896K 9232K 9226K 2
model 64K 48K 640K 1
database1 74M 18M 18M 2
dbadb 13520K 3392K 3383K 2
database2 780M 195M 195M 5
database3 40560K 10144K 10141K 2
database4 264M 66M 66M 2
database5 156M 39M 39M 3
database6 72M 18M 18M 4
database7 51M 12M 12M 5
database8 24592K 6160K 6151K 4
database9 12304K 3088K 3079K 3
database10 1552K 400K 1280K 2
database11 18448K 4624K 4615K 3
database12 43M 10M 10M 4
database13 9232K 2320K 2311K 2
database14 30672K 7680K 7671K 2
sybsystemdb 64K 48K 640K 1
sybsystemprocs 1232K 320K 640K 1
dbccdb 29504K 7392K 7380K 2

 

[sybaseguru]

Send the e-mail to mich@peridale.co.uk.

Also please do select @@version on the server (I Think you have given the version, I need to know your O/S as well).

Please also do "uname -a" on data server on O/S and state whether you are using this host for anything except this sybase server just to make sure

 

[sybaseguru]

Sorry forgot to ask, Is this table or database is bind to a private cache (as opposed to default data cache)?