MTQ - Split of Cores - 10.2.2

[Radhika]

Hello All,

Recently we have upgraded our TM1 environment from 9.5.2 to 10.2.2, OS: Windows. Now we are planning to enable MTQ, I have few questions ,can you please provide me inputs on the below points.

1) We have two TM1 instances ( input and reporting) on the same physical box and informatica client. No of cores which are available on this box is 40, what is the best practice to allocate cores to TM1 Instance and system process.
2) When we execute a Control TI which in turn executes multiple TI's (ex: 8) , when MTQ (maximum no of cores) is enabled, does this mean that all the TI's under the control job will be executed at one shot.
3) What are the things that I need to monitor when MTQ is enabled - Logs, Ops Console, CPU Utilization , Start gate views. Is there any control cube in TM1 which logs the transactions done per core.
4) Does it make any difference in server start time before and after implementing MTQ.

Thanks,
Radhika

[qml]

1) We have two TM1 instances ( input and reporting) on the same physical box and informatica client. No of cores which are available on this box is 40, what is the best practice to allocate cores to TM1 Instance and system process.

You can set MTQ=40 on both as cores get allocated to queries automatically based on query complexity and number of cores available during execution. The number of actually allocated cores will be much smaller for most queries anyway. Practical gains from setting it above, say, 16, are minimal due to diminishing returns, but there seems to be no downside to setting it higher.

2) When we execute a Control TI which in turn executes multiple TI's (ex: 8) , when MTQ (maximum no of cores) is enabled, does this mean that all the TI's under the control job will be executed at one shot.

No, MTQ has nothing to do with running TIs in parallel. It is only about MultiThreaded Queries.

3) What are the things that I need to monitor when MTQ is enabled - Logs, Ops Console, CPU Utilization , Start gate views. Is there any control cube in TM1 which logs the transactions done per core.

In TM1Top and/or the OpsConsole you should be able to see additional sub-threads being kicked off. As far as I am aware there is no other available form of monitoring.

4) Does it make any difference in server start time before and after implementing MTQ.

No, see my answer to question 2.