DISCOVER_MEMORYUSAGE

The DISCOVER_MEMORYUSAGE command is not well documented. Any chance someone from the dev team could give a brief definition of each field you get in the results of this command?

I'm hoping for a definition so I can provide better documentation here (see the field definitions at the bottom):

http://www.codeplex.com/ASStoredProcedures/Wiki/View.aspx?title=MemoryUsage&referringTitle=Home

Thanks.

I was doing research on this recently and this is the information I gathered:

CanShrink - true if it can shrink (represented in perfmon counter Shrinkable, versus Unshrinkable)

MemoryUsed - bytes of memory used

MemoryAllocated - bytes of memory allocated

MemoryAllocBase - bytes for base (initial) allocation

MemoryAllocFromAlloc - this is for recursive definitions

Elements - count of elements

I hope this helps.

|||

Thanks for the info. I probably shouldn't have asked for "brief" definitions as I was hoping for a little more info. But those definitions are better than nothing!

Some other questions if you should feel so inclined to answer:

1. What's considered an "element"? Does this tie to count of members in a dimension? Count of rows in a partition? Count of attribute hierarchies in a dimension?

2. What are recursive definitions?

3. Would it be more accurate to say that for memory that's shrinkable, it's the MemoryUsed or the MemoryAllocated that can be shrunk?

4. Any general suggestions for things to look for when you're studying the results of DISCOVER_MEMORYUSAGE?

5. Any feedback on the MemoryUsage class would be welcome: http://www.codeplex.com/ASStoredProcedures/Wiki/View.aspx?title=MemoryUsage&referringTitle=Home