TM1 Forum

Hi Guys

We have a single physical box, with multiple Tm1 models.

IBM recommends MTQ=ALL.
Is this still the case when you have multiple Tm1 models on one box?

Regards
Chris

I dont know why. But I always set it to max - 1. So if you have 4 threads, I set it to 3.

This way there are always some resources available for other system things.

Hi
To be fair, you should understand well how your databases are used to find the most optimized way. It depends on how these databases are used, parallel or different times, how long usually a query takes, how many users, how many cores in total you have, etc. I usually do not set it to ALL if I have multiple databases because in theory it may happen that if there is a long query on one of the databases then it uses up all cores. But also, if I have for example 16 cores, I do not allocate out exactly only 16 (i.e. in case of 4 databases 4 cores each), but more than 16 but less than 4x16. Really depends on the different databases. Maybe give to your biggest/most used one 75-80% of cores and then decrease for all others this % a bit. If most queries run within seconds and number of parallel users are not that high, then you could be close to ALL in all databases

Btw, I would be also interested to hear others' practices