What is using logical memory in my ASE server?

[sladebe]

My ASE server (16.0 SP04 PL04) reports it's using about 22.4 gbytes of memory (value of "total logical memory"), but the total of the memory config options is much less than that:

• 6.8 gbytes data cache configured
• 0.57 gbytes of procedure cache configured
• statement caching disabled
• abstract plan cache is configured to zero
• heap memory per user is about 28.6 mbytes (only about 18 threads running including systems threads)

I found this nice diagram of things which use memory in ASE:

https://help.sap.com/docs/SAP_ASE/91d32d977a174c68829880bc020fc352/a99af2a8bc2b1014b832d6a1b32724c8....

So I think I should only be using 10 gbytes or less.  But ASE says it's using much more than that.  Is that just normal overhead?  How can I figure out what's using memory? 

Thanks in advance
Ben

[sladebe]

I see this memory usage reported by monMemoryUsage:

> select SizeMbytes=TotalSize/1024/1024, MemoryPoolName, PoolType, ConfigOption 
> into #tmp
> from monMemoryUsage
go
> sp_autoformat "#tmp", "SizeMbytes,MemoryPoolName, PoolType, ConfigOption", null, "order by SizeMbytes desc"; | head -10
 SizeMbytes MemoryPoolName                PoolType ConfigOption                  
 ---------- ----------------------------- -------- ------------------------------
      22893 Global Block Pool             Block    NULL                          
        585 Proc Cache Header             Block    procedure cache size          
        343 Proc Stack                    Object   cnproc                        
        144 Pss                           Object   cfgpss                        
        115 Free Locks                    Fragment number of locks               
        100 Procbuf                       Object   procedure cache size          
        100 Rep Agent Memory Pool         Fragment replication agent memory size 
         34 Network Buffers               Bucket   NULL                          

[Mark_A_Parsons]

Where are you reading total logical memory from? (sp_configure?)

What are your settings for configs max memory and allocate max shared memory? (I know, that shouldn't affect total logical memory but I'm interested in that large Global Block Pool as I've seen that growing in conjunction with total physical memory.)

[sladebe]

Re: interested in that large Global Block Pool as I've seen that growing in conjunction with total physical memory

• total logical memory = 11727809 2k pages (~22.4 gbytes)
• max memory = 12900883 2k pages (~26.6 gbytes)
• allocate max shared memory was not set which is a whoops for us (normally it's set).  I have just set it/enabled it (set to 1)
• total physical memory = 12900884 2k pages (~26.6 gbytes)

So the data cache is set to 7000 mbytes, but actual memory used (total logical memory) is up around 22.4 gbytes.   This is not urgent.  We have enough memory on the box, but it's curious

[Mark_A_Parsons]

I'm running ASE 16.0 SP04 PL04 on a home (linux) server.

My total logical memory matches up (within a couple % points) with the totals from monMemoryUsage + total data cache.

If I were seeing this kind of discrepancy (while waiting for feedback from tech support?) I'd start looking for data that may not be showing up in monMemoryUsage, eg:

• review entire output from sp_configure looking for outsized total memory usage numbers
• review sp_configure Monitoring for some outsized MDA pipe max messages settings
• review output from sp_monitorconfig 'all' looking for outsized Max_Used values that could be eating up memory
• review the list of MDA tables; objective being to run queries against MDA tables that contain memory usage numbers; perhaps there are some items (eg, rep thread memory usage?) that are not accounted for in monMemoryUsage
• rule out connection-related issues by bouncing the ASE instance and bring up on a new/different port (that applications don't know about) and make sure all repagents are shutdown; primary objective is to see if total logical memory is in line with expected usage and if it is then look at monitoring user/application connections and repagent activity
• do other ASE instances show this same discrepancy in total logical memory? if 'no', what's different between the ASE instances?

I'm assuming sp_configure memory is reporting (at the end) that ~4.2 GB of memory is available for use, right?