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

• 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.

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

CR806700, CR#806700, 806700, elc_cache, CR805272,  CR#805272, 805272, inaccurate , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed