cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with sybase ase max memory

Former Member
0 Kudos

Hi Team,

I have a strange issue ,

1> sp_configure "max memory" , 0 , "12G"
2> go
Msg 10841, Level 16, State 1:
Server 'PS1', Procedure 'sp_configure', Line 1310:
The value of parameter 'max memory' '6291456' cannot be less than the 'total logical memory' size '7291579'. Please reconfigure 'max memory' to be greater than or equal to the total logical memory required.
(return status = 1)


I want to reduce the value max memory due to high swapping on the server.

1> sp_cacheconfig

2> go

Cache Name Status Type Config Value Run Value

------------------------------------------------------------------------ -------------------------------- -------------------------------- -------------------------------------------------------- ------------------------------------------------

default data cache Active Default 10240.00 Mb 10240.00 Mb

log cache Active Log Only 512.00 Mb 512.00 Mb

(1 row affected)

------------ ------------

Total 10752.0 Mb   10752.0 Mb

==========================================================================

Cache: default data cache,   Status: Active,   Type: Default

      Config Size: 10240.00 Mb,   Run Size: 10240.00 Mb

      Config Replacement: strict LRU,   Run Replacement: strict LRU

      Config Partition: 16,   Run Partition:           16

IO Size  Wash Size     Config Size  Run Size     APF Percent

-------- ------------- ------------ ------------ -----------

    16 Kb     512000 Kb   5120.00 Mb   5120.00 Mb     50

   128 Kb     512000 Kb   5120.00 Mb   5120.00 Mb     50

==========================================================================

Cache: log cache,   Status: Active, Type: Log Only

      Config Size: 512.00 Mb,   Run Size: 512.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

-------- ------------- ------------ ------------ -----------

    16 Kb 2448 Kb     12.00 Mb     12.00 Mb     50

    32 Kb      61440 Kb    500.00 Mb    500.00 Mb     50

i am struggling to find out what else to reduce.

Accepted Solutions (0)

Answers (1)

Answers (1)

JanStallkamp
Employee
Employee
0 Kudos

Hi.

Currently your data caches are 10.5 GB. There are some other memory consumers (proc cache, SQL cache...) and they currently add up to more than 12GB. You will need to reduce memory consumption first before reducing 'max memory'.

Regards,

Jan