2471654 - sp_monitorconfig reports inaccurate statistics for additional network memory | SAP Knowledge Base Article

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",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.