Turning on the performance monitor in PAW

Post Reply
User avatar
Steve Rowe
Site Admin
Posts: 2417
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Turning on the performance monitor in PAW

Post by Steve Rowe »

Hi,
I don't have any of the legacy clients available to me and so have no way to see the cube sizes and also I cannot see an option to turn on the performance monitor so can monitor and track cube sizes.

Anyone seen an option to enable this anywhere?

Thanks in hope!
Technical Director
www.infocat.co.uk
User avatar
Elessar
Community Contributor
Posts: 340
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Turning on the performance monitor in PAW

Post by Elessar »

Hi

Generally speaking you can, but you need to go roundabout ways: in Administration, server configuration, you can change some tm1s.cfg parameters including PerformanceMonitorOn. PerformanceMonitorOn is dynamic, so this will turn it on immediately.
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
User avatar
Steve Rowe
Site Admin
Posts: 2417
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Turning on the performance monitor in PAW

Post by Steve Rowe »

You can turn on the option in the cfg editor of PAW in Administration / YourDB / Configuration / Default / PerformanceMonitorOn

Unfortunately this method requires a restart of the DB if you change it through the console.

Although the documentation states if you change it in the cfg it is dynamic. (I don't have access to this though...)

Restarting will destroy the very information I am trying to analyse of course, so super-impractical....

Aren't Friday afternoons great!
Technical Director
www.infocat.co.uk
User avatar
Elessar
Community Contributor
Posts: 340
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Turning on the performance monitor in PAW

Post by Elessar »

I've checked this now: it does turn perfmon On without server restart (literally PAW adds "PerformanceMonitorOn=T" row in tm1s.cfg file)
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
User avatar
Steve Rowe
Site Admin
Posts: 2417
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Turning on the performance monitor in PAW

Post by Steve Rowe »

Yeah, did I mention it was Friday afternoon??

Never trust the documentation!

Now I just need to understand that fact that

Cube RAM totals 1.5GB
Server RAM =10.5GB
Garbage = 0.8GB
Taskmanager states 10.5 GB

So which is wrong...Garbage or Cube.....

Thanks for your help Elessar, have a great weekend!
Technical Director
www.infocat.co.uk
Wim Gielis
MVP
Posts: 3118
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Turning on the performance monitor in PAW

Post by Wim Gielis »

You could also use the REST API to change settings.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
gtonkin
MVP
Posts: 1199
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Turning on the performance monitor in PAW

Post by gtonkin »

Steve Rowe wrote: Fri May 12, 2023 4:42 pm ... So which is wrong...Garbage or Cube.....
If there is a process running, you would not see how much memory it is consuming with transactions in case it needs to roll back.
And then don't forget that all the dims, sets etc. eat memory too - can still use the properties window in architect from the rich environment if you need to check dimension memory usage.

Failing that, could be a memory leak, there apparently were some issues fixed in PA 2.0.9.17 and we have recently upgraded our cloud Dev environment to check this out as we have had similar issues doing the math and coming up short, even on afternoons other than Friday.
Post Reply