1930595 - sp_monitorconfig 'heap memory per user' is reporting Pct_act at 100% - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1930595 - sp_monitorconfig 'heap memory per user' is reporting Pct_act at 100% - SAP ASE

Symptom

  • sp_monitorconfig "heap memory per user" is reporting Pct_act at 100%:

 Name                      Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name     
 ------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
 heap memory per user                0       25895 100.00        25895           0 NULL  

  • The Num_active and Max_Used counters may exceeed the configured value for the "heap memory per user" parameter:

sp_configure:

Parameter Name                 Default     Memory Used Config Value Run Value    Unit                 Type
------------------------------ ----------- ----------- ------------ ------------ -------------------- --------------------
heap memory per user                  4096   109981696         6144         6144 bytes                dynamic

sp_monitorconfig:

Name                      Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
heap memory per user                0        8360 100.00         8360           0 NULL

  • The Reuse_cnt counter remains set to 0 (zero).

Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

CR400980, CR#400980, 400980, config_admin, global, pool , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.