Dear Informix group user,
Greeting from Amit Patel , hope all are safe and healthy in Covid-19 Era.
I need a suggestion .
In my new project , my customer has 1 TB of RAM and using only 38 GB as SHARED MEMORY with having 10 TB data size and they are feeling Server slowness.
So far I've not got into the system , as project is likely to start and only got information from customer side.
So what could be the assumption ?
Should I say customer to share 75-80% RAM as SHARED MEMORY ? (means around 800 GB)
or
Should I increase Shared Memory around 100 GB and BUFFERPOOL , SHMVERTSIZE parameter?
Please advise.
Thanks
Amit Patel
------------------------------
AMIT PATEL
------------------------------
#Informix