Perfmon counters after cube optimization

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

Perfmon counters after cube optimization

Post by lotsaram »

Here's some trivia for you all. What happens to the TM1 performance monitor counters when cubes are optimized (dimension re-indexing)?
They go stark raving mad is what.
WTF? Awesome, negative database memory consumption, a world first!
WTF? Awesome, negative database memory consumption, a world first!
PerfmonPostOpt.jpg (39.18 KiB) Viewed 1638 times
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Perfmon counters after cube optimization

Post by declanr »

That's ace. I've seen many "odd" occurrences in the stats cubes at the best of times so tend to use the results with a great deal of caution anyway.

I also have extreme hesitation around using the re-ordering and if time allows prefer to export all the data and then rebuild it manually. It seems the oddities are different in every version of the tool as well... it all just adds to the excitement of course!
Declan Rodger
Post Reply