MTQ

Post Reply
TM1NB
Posts: 15
Joined: Thu Jan 02, 2020 3:05 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 365

MTQ

Post by TM1NB » Thu Nov 12, 2020 9:57 am

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

lotsaram
MVP
Posts: 3439
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: MTQ

Post by lotsaram » Thu Nov 12, 2020 10:58 am

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")
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

TM1NB
Posts: 15
Joined: Thu Jan 02, 2020 3:05 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 365

Re: MTQ

Post by TM1NB » Thu Nov 12, 2020 4:44 pm

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

Emixam
Posts: 84
Joined: Tue May 21, 2019 3:33 pm
OLAP Product: TM1
Version: PA 2.0.x
Excel Version: 2016
Location: The Internet

Re: MTQ

Post by Emixam » Thu Nov 12, 2020 5:18 pm

Hello,

Based on IBM website,
MTQ=n where n represents the number of threads to be used for a single operation.

And by definition,
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.
You can also have a quick look at your Processor CPU Specifications on Intel website.



And now, to answer your questions,
TM1NB wrote:
Thu Nov 12, 2020 9:57 am
So my question is, is my MTQ limit 16 because 2*8 cores or is ist 32 because of the 2*16 logical processors?
16 if you have 8 cores, 32 if you have 16 cores
TM1NB wrote:
Thu Nov 12, 2020 9:57 am
And what happens when the MTQ parameter in the .cfg is bigger than the server hardware allows?
I have no idea.. be safe, don't try !

Have a good day
Sorry for my English :)

TM1NB
Posts: 15
Joined: Thu Jan 02, 2020 3:05 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 365

Re: MTQ

Post by TM1NB » Mon Nov 16, 2020 12:24 pm

Hi again,

so this seems to be the important part here:
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.
-> My max MTQ limit is 32, because each core (2 x 8) can handle 2 threads. :D

Thanks @ all

Post Reply