SAP Knowledge Base Article - Preview

3087788 - sp_sysmon incorrectly calculates wash dirty - SAP ASE

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

SAP Adaptive Server Enterprise 16.0

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.