I have an SAP ECC 6.0 EHP5 running with SAP MAX-DB on SUSE Linux.
we have allocated 30 GB of RAM to this machine, both data base and SAP app server are running under same host or physical application server.
In the process of performance tuning i have allocated 20 GB of RAM to SAP using em/initial_size_mb and based on this i have adjusted other SAP profiles parameters .
Now i want to allocate 8 GB of RAM to database , can any one please help me how to allocate this fixed amount of RAM to database MAX DB so that if any query runs on database it responds very fast.
From my understanding SAP MAX-DB uses cache_size to read content from database please correct me if i am wrong.
My current CacheMemorySize is 350080 , can i increase this value to higher level so that my max db performance also increases when ever you are running any query on database.
When i open TX SPRO and expand nodes it takes lots of time to respond, i have changed parameters related to SAP but i have done nothing related to MAX DB. Please help me understand how can i increase performance of maxdb.
On 30 gigs of memory there are only 10 active users , I want this machine to be running on ample speed its a very critical machine for us.
My MAX - DB Release - " 7.9.08.008 ".DB client lib. " SQLDBC 7.8.1.014 " DB releases " MaxDB 7.7, MaxDB 7.8 , MaxDB 7.9 " DBSL version " 720.00 "
DBSL Patch Level " 441 "
Please let me know if you need any further logs.
Thanks in advance !!