Page 1 of 1

Level of accuracy in Stats cubes

Posted: Thu Apr 08, 2010 9:19 am
by Steve Rowe
Morning from a lovely sunny London, I just thought I would point that out since we don't get many days like this and of course I realise I'm conforming to my stereotype of talking about the weather for no apparent reason.

Anyway back to the topic in hand.

I know the stats for server information can be a little inaccurate but I seem to be missing a half gig of RAM some where....
Task Manager states total usage = 6.2 GB
Stats for Server gives
Total Usage of 6.3 GB
Mem in Garbage of 0.5 GB

All ok so far that makes sense, but...
Stats for Cubes give total memory usuage of 5.4 GB
So with the garbage memory taking the 6.3 to 5.8 that still leaves me with around 0.4 of a GB unaccounted for.

So am I missing something or is that just as accurate as the stats for server gets?

(64 bit 9.0 running on Windows server 2003)

Cheers

Re: Level of accuracy in Stats cubes

Posted: Thu Apr 08, 2010 10:38 am
by lotsaram
My assumption would be that the missing ~0.4 Gb is memory consumption by dimensions & security ... no stats cubes for these.

Re: Level of accuracy in Stats cubes

Posted: Thu Apr 08, 2010 10:56 am
by Steve Rowe
Hmm OK, well the stats for cubes info contains all the control cube data so I guess that does just leave dimensions and security. Dimensions are (I believe) tiny when we are talking about GB scale so this would mostly leave the security.

Anyone fancy looking at the metrics of their system and seeing what the missing bit is?

Cheers

Re: Level of accuracy in Stats cubes

Posted: Thu Apr 08, 2010 11:10 am
by lotsaram
If you have the properties pane on in server explorer you can see the memory consumption by dimension (not sure if this includes attributes though, have never really looked that closely.)