Hi together,
I've a short question about how to figure out the max possible MTQ value for the TM1s.cfg.
The servers hardware is the following:
Prozessor Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz, 3300 MHz, 8 Kern(e), 16 logische(r) Prozessor(en)
Prozessor Intel(R) Xeon(R) CPU E5-2667 v2 @ 3.30GHz, 3300 MHz, 8 Kern(e), 16 logische(r) Prozessor(en)
So my question is, is my MTQ limit 16 because 2*8 cores or is ist 32 because of the 2*16 logical processors?
And what happens when the MTQ parameter in the .cfg is bigger than the server hardware allows?
Thanks
MTQ
-
- MVP
- Posts: 3703
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: MTQ
You can use
MTQ=ALL
or
MTQ=-1
... to utilise all processors
Or if you want to be conservative and always leave 1 processor free for the OS to do other stuff
MTQ=-2
... to utilise all available processors less one
Unless you have a hulking monster server with 96 or more processors then I would always use this for MTQ versus setting a hardcoded number.
And for completeness to DISABLE MTQ
MTQ=1
or
MTQ=0
... (which explains the seemingly illogical -1 for "ALL")
MTQ=ALL
or
MTQ=-1
... to utilise all processors
Or if you want to be conservative and always leave 1 processor free for the OS to do other stuff
MTQ=-2
... to utilise all available processors less one
Unless you have a hulking monster server with 96 or more processors then I would always use this for MTQ versus setting a hardcoded number.
And for completeness to DISABLE MTQ
MTQ=1
or
MTQ=0
... (which explains the seemingly illogical -1 for "ALL")
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 18
- Joined: Thu Jan 02, 2020 3:05 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: Excel 365
Re: MTQ
Hi lotsaram,
thanks for your reply. Yes, I know the possibilities how to config the MTQ parameter. My question is more about the specs for the Intel(R) Xeon(R) CPU I posted. I'm not sure about the definition what MTQ can use here as parameter. The 16 cores or the 32 logical processors?
Thanks
thanks for your reply. Yes, I know the possibilities how to config the MTQ parameter. My question is more about the specs for the Intel(R) Xeon(R) CPU I posted. I'm not sure about the definition what MTQ can use here as parameter. The 16 cores or the 32 logical processors?
Thanks
-
- Regular Participant
- Posts: 156
- Joined: Tue May 21, 2019 3:33 pm
- OLAP Product: TM1
- Version: PA 2.0.x
- Excel Version: 2016
- Location: The Internet
Re: MTQ
Hello,
Based on IBM website,
And by definition,
And now, to answer your questions,
Have a good day
Based on IBM website,
MTQ=n where n represents the number of threads to be used for a single operation.
And by definition,
You can also have a quick look at your Processor CPU Specifications on Intel website.The number of threads you have depends on the number of cores in your CPU. Each CPU core can have two threads. So a processor with two cores will have four threads. A processor with eight cores will have 16 threads.
And now, to answer your questions,
16 if you have 8 cores, 32 if you have 16 cores
I have no idea.. be safe, don't try !
Have a good day
-
- Posts: 18
- Joined: Thu Jan 02, 2020 3:05 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: Excel 365
Re: MTQ
Hi again,
so this seems to be the important part here:

Thanks @ all
so this seems to be the important part here:
-> My max MTQ limit is 32, because each core (2 x 8) can handle 2 threads.The number of threads you have depends on the number of cores in your CPU. Each CPU core can have two threads. So a processor with two cores will have four threads. A processor with eight cores will have 16 threads.

Thanks @ all