How to make TM1 server use lesser number of cores than avail

Post Reply
nilmadhab.laha
Posts: 12
Joined: Sun Feb 09, 2014 2:15 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

How to make TM1 server use lesser number of cores than avail

Post by nilmadhab.laha »

Hi All,

Is there any way /any setting - by which we can dictate how many cores will be utilized by TM1 servers?
For example - we have a machine - which has 24 CPU cores. OS is Windows 2008 R2, 64 bit Enterprise server. Can we make TM1 use only 16 cores out of available 24 cores by some setting?

I understand the parameter "MaximumCubeLoadThreads" in tm1s.cfg is used to make the TM1 server loading multi-threaded. Is it used just for server loading purpose - or it also dictates the number of CPU cores to be used when server is loaded - when I run a heavy TI process / or say 100 concurrent users fire query on the server?
Any help will be much appreciated.

--
Thanks and Regards.
N. Laha.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: How to make TM1 server use lesser number of cores than a

Post by jim wood »

I know you can do this on Nix but that's a feature of Unix not Windows. Unix is much better at managing resources. I can't say for certain that there is no way of doing this on windows as I've not tried it but I doubt it's easy to do, if you can at all,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Paul Segal
Community Contributor
Posts: 306
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: How to make TM1 server use lesser number of cores than a

Post by Paul Segal »

Run it as a virtual machine and limit the cores using the vm settings?
Paul
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: How to make TM1 server use lesser number of cores than a

Post by jim wood »

Good plan. That's one way of doing it.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
TableManagerOne
Posts: 42
Joined: Fri Apr 19, 2013 7:07 pm
OLAP Product: TM1
Version: 10.1 RP1 FP1
Excel Version: 2003 SP3

Re: How to make TM1 server use lesser number of cores than a

Post by TableManagerOne »

Search "Windows processor affinity". You can assign specific processors to an instance of TM1 before or after it has been launched.
User avatar
stephen waters
MVP
Posts: 324
Joined: Mon Jun 30, 2008 12:59 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: Excel 2010

Re: How to make TM1 server use lesser number of cores than a

Post by stephen waters »

TableManagerOne wrote:Search "Windows processor affinity". You can assign specific processors to an instance of TM1 before or after it has been launched.
I could be wrong but I assume the OP is trying to limit the number of cores for licensing purposes ( ie reducing the PVU count) ? If so, I wonder if this method would be accepted by IBM (with or without the IBM license monitoring tool)
tomok
MVP
Posts: 2832
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: How to make TM1 server use lesser number of cores than a

Post by tomok »

stephen waters wrote:If so, I wonder if this method would be accepted by IBM (with or without the IBM license monitoring tool)
I'm pretty sure the answer to that would be a resounding no.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
nilmadhab.laha
Posts: 12
Joined: Sun Feb 09, 2014 2:15 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Re: How to make TM1 server use lesser number of cores than a

Post by nilmadhab.laha »

@Stephens : Yes you are absolutely right - I am trying to do it for licensing compliance purpose - reducing PVU count. So, process affinity setting, wont work.

@ All : Thanks a lot. Looks like, I can safely conclude - Its a no, It can't be managed in TM1. Either it has to be managed in OS Level (UNIX) or using a VM ware.
Post Reply