There are several ADMIN COMMANDs available for monitoring memory consumption.
ADMIN COMMAND 'info imdbsize'
The ADMIN COMMAND 'info imdbsize' command returns the current amount of memory allocated to use by in-memory database tables and indexes. The value returned is a VARCHAR, and it indicates the number of kilobytes used by the server. The command returns the amount of virtual memory used, not the amount of physical memory used.
In time, the value of imdbsize can grow, because returning data back to operating system can only be done in allocation units which need to be completely unused before they can be returned back to the operating system.
Transient memory allocations (such as SQL execution graphs) are excluded from the ADMIN COMMAND 'info imdbsize' report.
ADMIN COMMAND 'info processsize'
The ADMIN COMMAND 'info processsize' command returns the virtual memory process size, that is, the full address space size of the database server that the in-memory database process uses. The value returned is a VARCHAR, and it indicates the number of kilobytes used by the process. This command returns the amount of virtual memory used, not the amount of physical memory used.
ADMIN COMMAND 'pmon mme'
There are also several performance counters available, which include the runtime information related to the in-memory database server.
The ADMIN COMMAND 'pmon mme' command produces the following list of current values of counters:
RC TEXT -- ---- 0 Performance statistics: 0 Time (sec) 30 21 Total 0 MME current number of locks : 0 0 0 0 MME maximum number of locks : 0 0 0 0 MME current number of lock chains : 0 0 0 0 MME maximum number of lock chains : 0 0 0 0 MME longest lock chain path : 0 0 0 0 MME memory used by tuples : 0 0 0 0 MME memory used by indexes : 0 0 0 0 MME memory used by page structures: 0 0 0 10 rows fetched.
In the performance statistics listing, the amount of memory used by tuples, indexes, and page structures is given in KB.
ADMIN COMMAND 'memory'
The ADMIN COMMAND 'memory' command reports the amount of dynamically allocated heap memory. In heap-based memory allocation, memory is allocated from a large pool of unused memory area called the heap. The size of the heap memory allocation can be determined at runtime. Transient memory allocations (such as SQL execution graphs) are included in the ADMIN COMMAND 'memory' report.