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
MTQ Settings
-
Bakkone
- Posts: 119
- Joined: Mon Oct 27, 2014 10:50 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: MTQ Settings
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.
This way there are always some resources available for other system things.
-
mvaspal
- Community Contributor
- Posts: 341
- Joined: Wed Nov 03, 2010 9:16 pm
- OLAP Product: tm1
- Version: 10 2 2 - 2.0.5
- Excel Version: From 2007 to 2013
- Location: Earth
Re: MTQ Settings
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
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