SAP Knowledge Base Article - Preview

2471654 - sp_monitorconfig reports inaccurate statistics for additional network memory

Symptom

The system stored procedure sp_monitorconfig reports inaccurate statistics for additional network memory in normal and full mode.

1> sp_monitorconfig 'additional network memory',null,full
2> go
Usage information at date and time: May 10 2017 11:14AM.
 Name                                Configure Value System Value Run Value   Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
 ----------------------------------- --------------- ------------ ----------- ----------- ----------- ------- ----------- ----------- ------------------------------
 additional network memory                  10485760     20685892    27433977           0    27433977  100.00    27433977           0 NULL
(1 row affected)
(return status = 0)
  • Configure Value represents the value of "additional network memory"
  • System Value represents the pre-allocated memory for network buffers based on "user connections"
  • Run Value represents the current memory in use (incorrect, it should be the same as Configure Value)
  • Num_free shows 0, which is incorrect
  • Num_active is the current Network Buffers in use
  • Pct_act is incorrect is this is reporting the in use is fully allocated
  • Max_Used is the high water mark for memory in use.  This is often incorrect as well.

Example of correct output

1> sp_monitorconfig 'additional network memory',null,full
2> go
Usage information at date and time: May 10 2017 11:21AM.
 Name                                Configure Value System Value Run Value   Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
 ----------------------------------- --------------- ------------ ----------- ----------- ----------- ------- ----------- ----------- ------------------------------
 additional network memory                  10485760     20685892    10485760     7512656     2973104   28.35     2998800           0 NULL
(1 row affected)
(return status = 0)

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP138

Product

SAP Adaptive Server Enterprise 15.7

Keywords

additional network memory, sp_monitorconfig, bucketpool, bucket 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.