How to increase Memory in Sybase and which parameter should affect ?

[Former Member]

Hello All,

I want to increase Memory in ASE Sybase 15.7

Which parameter should require to reconfigure ?

Right now we have 48 GB Memory in Server and 21 GB allocated to Sybase DB but we are facing too slow in pick hours. planning to 16 GB increase and want to allocate 12 GB for Sybase but don't know how to reconfigure

Current Configuration

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

OS - Windows Server 2008 R2

SAP - ECC6 EHP6

SAP Users - 900

Max Memory - 11320000 (2K)

Total Logical Memory - 3158101 (2K)

[Former Member]

Thanks Mark for Reply

My Confusion is

If i allocated 12 GB Memory for sybase than how many types memory should configured

eg. sp_configure 'max memory' 6291456 (2K)

what about other memory should configure and what size ,like proc cache, statement cache, descriptor counts, data caches etc.

Also i got from one of scn blog mentioned "procedure cache should 30 to 40 % of Max memory" but m still confused about other memory, so please clarify what should i do ?

[Mark_A_Parsons]

How to configure memory within ASE (eg, proc cache, statement cache, data caches, number of locks/connections/descriptors/etc) depends on your environment and where the memory will be of best use.

One approach would be to bump up the big memory users (data caches, proc/statement cache) by the same percentage that you're bumping up 'max memory' (ie, from 21GB to 33GB is about 50%, so bump up your big memory users by 50%).

If sp_sysmon is showing no performance issues with proc/statement cache then perhaps just putting all of the memory into your data cache(s) should be sufficient.

If you've done some thorough analysis of MDA/OpenObjectActivity metrics perhaps you want to put some of that extra/new memory into a named data cache and bind some specific tables/indexes to this new data cache.

The possibilities go on and on and on ... and they all depend on your specific environment and the associated performance metrics.