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.