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: 3960
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.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Paul Segal
Community Contributor
Posts: 312
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: 3960
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.
Go Build a PC
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: 2836
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