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 for Me (Login required).

Search for additional results

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