Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

Sybase - sp_cacheconfig

Hello there,
I'm little loss with sp_cacheconfig, what is this use for and how the cacheconfig will help to improve total performance of ASE ? what are the different between cacheconfig and sp_configure 'memory' ??

1> sp_cacheconfig
2>
 Cache Name         Status   Type     Config Value   Run Value
 ------------------ -------- -------- -------------- ------------
 default data cache Active   Default    1000.00 Mb     1000.00 Mb
                                   ------------ ------------
                            Total    1000.00 Mb   1000.00 Mb
==========================================================================
Cache: default data cache,   Status: Active,   Type: Default
      Config Size: 1000.00 Mb,   Run Size: 1000.00 Mb
      Config Replacement: strict LRU,   Run Replacement: strict LRU
      Config Partition:            1,   Run Partition:            1
 IO Size  Wash Size     Config Size  Run Size     APF Percent
 -------- ------------- ------------ ------------ -----------
     2 Kb      61440 Kb    750.00 Mb    750.00 Mb     10
     4 Kb      10240 Kb     50.00 Mb     50.00 Mb     10
    16 Kb      40960 Kb    200.00 Mb    200.00 Mb     10
(return status = 0)
1>
ASKER CERTIFIED SOLUTION
Avatar of alpmoon
alpmoon
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial