motioneye
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>
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.