JVM Sizing Guideline for Teiid

[j3hntan]

Hi,

I was wondering what is appropriate sizing for teiid say we run 2 CPU, 8 GB RAM instance with 4-5 virtual databases. One of our virtual database has about 20 tables in internal materialization (max 300,000 records - total about 1 mil records).

[rareddy]

John,

For 7.3, see

http://docs.jboss.org/teiid/7.3.0.Final/admin-guide/en-US/html_single/#performance

https://community.jboss.org/wiki/CalculatingRequiredHeapSizesInTeiidATechTalkWithSteveH

Note that once the initial memory requirements are met, Teiid can limit itself with the available memory. If there is more memory available then you can increase the batch sizes and active plan counts depending upon your scalability needs. 7.5/7.6 few more improvements in this area where you can allocate a block of memory for internal Teiid batching purposes, and also it auto-sizes the batches depending upon the memory availability.

Ramesh..