1872097 - sp_monitorconfig "number of sort buffers" shows higher values of Num_active and Max_Used than configured. - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1872097 - sp_monitorconfig "number of sort buffers" shows higher values of Num_active and Max_Used than configured. - SAP ASE

Symptom

  • sp_monitorconfig "number of sort buffers" shows higher values of Num_active and Max_Used than configured.

sp_configure:

Parameter Name                 Default     Memory Used     Config Value    Run Value     Unit                 Type
-------------------------------------- ----------- ----------- ------------ ------------ -------------------- --------------------
number of sort buffers                 500           0        12000     12000    number               dynamic

sp_monitorconfig:

Name                      Num_free    Num_active  Pct_act Max_Used    Reuse_cnt   Instance_Name
------------------------------------- ----------- ----------- ------- ----------- ----------- ------------------------------
number of sort buffers              0      526188 100.00       526188           0 NULL

  • Reuse_cnt counter still remains 0 (zero).

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions

Keywords

712042, CR712042, CR#712042, "sort buffer waits", sp_sysmon, server-wide, per-sort, multiple, connection , 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.