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.