Symptom
Procedure "sp_sysmon" recommends to increase "housekeeper free write percent" even when there are few dirty washes.
Example:
******
Housekeeper Task Activity
-------------------------
per sec per xact count % of total
------------ ------------ ----------
Buffer Cache Washes
Clean 229.8 0.4 71230 99.8 %
Dirty 0.4 0.0 125 0.2 %
------------ ------------ ----------
Total Washes 230.2 0.4 71355
Garbage Collections 2.8 0.0 854 n/a
Pages Processed in GC 1.0 0.0 299 n/a
Statistics Updates 0.5 0.0 154 n/a
Tuning Recommendations for Housekeeper
--------------------------------------
- Consider increasing the 'housekeeper free write percent' configuration parameter.
******
The Dirty washes was only 0.2% so there's no need to increasing free write percent.
Read more...
Environment
SAP Adaptive Server Enterprise 16.0 SP03 PL09
Product
Keywords
sp_sysmon sysmon consider increasing the housekeeper free write percent configuration parameter Buffer Cache Washes dirty wash CR 825383 CR825383 , 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