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.
SAP Knowledge Base Article - Preview