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!
Turning on the performance monitor in PAW
- Steve Rowe
- Site Admin
- Posts: 2455
- 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
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- Elessar
- Community Contributor
- Posts: 412
- 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
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.
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.
- Steve Rowe
- Site Admin
- Posts: 2455
- 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
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!
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
www.infocat.co.uk
- Elessar
- Community Contributor
- Posts: 412
- 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
I've checked this now: it does turn perfmon On without server restart (literally PAW adds "PerformanceMonitorOn=T" row in tm1s.cfg file)
- Steve Rowe
- Site Admin
- Posts: 2455
- 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
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!
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
www.infocat.co.uk
-
- MVP
- Posts: 3223
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Turning on the performance monitor in PAW
You could also use the REST API to change settings.
Best regards,
Wim Gielis
IBM Champion 2024-2025
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
Wim Gielis
IBM Champion 2024-2025
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
- gtonkin
- MVP
- Posts: 1254
- 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
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.