Symptom
- sp_monitorconfig reports "number of sort buffer" 100% active
sp_monitorconfig "sort buffer"
go
Name Num_free Num_active Pct_act Max_Used Reuse_cnt Instance_Name
----------------------------- ------------- ---------------- ----------- -------------- --------------- -------------------
number of sort buffers 0 2210 100.00 2210 0 NULL
- Are there any negative impact with "number of sort buffers" being 100% utilized?
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
Product
Keywords
metadata, performance, reuse, count, sp_sysmon, parallel, multiple , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.