PDA

View Full Version : default data cache settings

kiran
12-13-01, 18:36
hi all

we are running Adaptive Server Enterprise/11.9.2.4 on a Sun box

and we are running into few performance issues.we are using lot of
temp tables and insert into and huge procedures

and i had a look at the settings for default data cache , and it reads
as below,

Available space: 483.69 MB
Current size : 483.69 MB
Currently configured: 0.00 MB


does these figures look ok ?
any suggestions , please ?

truly
kiran
MattR
12-13-01, 22:58
Originally posted by kiran
Available space: 483.69 MB
Current size : 483.69 MB
Currently configured: 0.00 MB


Kiran,

That looks like output from Sybase Central. It isn't currently working on my box but if I recall correctly the 'Currently Configured' option allows you to re-size the cache from the GUI. In any rate, I think you're OK but what would help is if you ran something like:

1> sp_cacheconfig
2> go
ffeingol
12-14-01, 00:28
You prob. also want to run sp_sysmon. It's really hard to say if that is enough cache w/o knowing how big the databases are, how much memory you have on the box etc.

Frank
kiran
12-14-01, 14:13
hi matt
thanks for the info, as you have asked , here is the output
from sp_cacheconfig.

1> sp_cacheconfig
2> go
Cache Name Status Type Config Value Run Value
------------------------------ --------- -------- ------------ ------------
default data cache Active Default 0.00 Mb 480.28 Mb
------------ ------------
Total 0.00 Mb 480.28 Mb
================================================== ========================
Cache: default data cache, Status: Active, Type: Default
Config Size: 0.00 Mb, Run Size: 480.28 Mb
Config Replacement: strict LRU, Run Replacement: strict LRU
IO Size Wash Size Config Size Run Size APF Percent
-------- --------- ------------ ------------ -----------
2 Kb 61440 Kb 0.00 Mb 480.28 Mb 10
(return status = 0)

thinks are in control now , but occassinally the db slows down, so
am in the process of taking preventive steps.

any suggestions with in the info above ?

kiran
Originally posted by MattR


Kiran,

That looks like output from Sybase Central. It isn't currently working on my box but if I recall correctly the 'Currently Configured' option allows you to re-size the cache from the GUI. In any rate, I think you're OK but what would help is if you ran something like:

1> sp_cacheconfig
2> go
kiran
12-14-01, 14:21
Originally posted by ffeingol
You prob. also want to run sp_sysmon. It's really hard to say if that is enough cache w/o knowing how big the databases are, how much memory you have on the box etc.

Frank

hi frank

thanks for the suggestion.
sure i will post soon with the output from sp_sysmon

kiran
ffeingol
12-15-01, 01:34
You will get a ton of info from sp_sysmon.

Check the results for cpu utilization, cache utilization and IO rates.

Frank