2492262 - sp_monitorconfig shows invalid counters Max_Used and Num_Active for several parameters - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2492262 - sp_monitorconfig shows invalid counters Max_Used and Num_Active for several parameters - SAP ASE

Symptom

  • Incorrect Max_Used and Num_Active counters in sp_monitorconfig are reported incorrectly for:
    • audit queue size
    • number of open objects
    • number of open indexes
    • disk i/o structures
       
  • For example, when “audit queue size” is set to 300, sp_monitoriconfig outputs collected after the ASE server reboot show Max_Used counts for “audit queue size” as either 300 or 0: 

Name                      Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
                              ------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
audit queue size                  263          37  12.33          300           0 NULL
audit queue size                  268          32  10.67          300           0 NULL
audit queue size                  287          13    4.33          300           0 NULL
….
audit queue size                  287          13   4.33           300           0 NULL
audit queue size                  279          21   7.00           300           0 NULL
audit queue size                  300            0   0.00              0            0 NULL
audit queue size                  300            0   0.00              0            0 NULL
audit queue size                  300            0   0.00              0            0 NULL

  • For example, Num_active  and Max_Used counters for "number of open objects" in sp_monitorconfig exceed the configuration value:

Parameter Name                 Default     Memory Used Config Value Run Value    Unit                 Type
------------------------------ ----------- ----------- ------------ ------------ -------------------- --------------------
number of open objects                 500       40442        3531        3531 number               dynamic

Name                      Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
number of open objects           6341        9957  100.00        9957           0 NULL

  • For example, Num_active  and Max_Used counters for "number of open indexes" in sp_monitorconfig exceed the configuration value:

Parameter Name                 Default     Memory Used Config Value Run Value    Unit                 Type
------------------------------ ----------- ----------- ------------ ------------ -------------------- --------------------
number of open indexes                 500       19028         3502         3502 number               dynamic

Name                      Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
number of open indexes              0        3609  100.00        3609           0 NULL

  • ASE is running with multiple engines.
  • Threaded kernel mode is enabled.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR806700, CR#806700, 806700, elc_cache, CR805272,  CR#805272, 805272, inaccurate , 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.