-XMX settings recommendation

#1

The default is 256M  what is the recommended settings based on?  It is the size of the DB? number of connections? 

If the DB has over 200GB of data and max connection of 400 then will I need to make this settings higher?  Thanks.

#2

There is no magic formula, but usually larger is better, as long as you have sufficient RAM.

You can track the actual heap size in production and see if it is sufficient.

If you have RAM constraints and the heap size is tight, you may have to reduce the sizes of the processing cache, the L2 data cache, and the query results cache.

ObjectDB Support

Reply