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 for Me (Login required).

Search for additional results

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