Tuned Profile Settings for Adaptive Server Linux

[tilman_model-bosch]

i ,

We are preparinng to Migrate our ASE servers  to upgraded Linux Hosts running RHEL 8.8.  We ran into a performance in writing to Disk . Issues related to this kba : https://me.sap.com/notes/2585416/E

The recommendation  change:

kernel.sched_min_granularity_ns = 10000000
kernel.sched_wakeup_granularity_ns = 15000000

to

kernel.sched_min_granularity_ns = 3000000
kernel.sched_wakeup_granularity_ns = 4000000

We made those changes and saw major improvements .  Now the question ---By default Linux servers  are using  the tuned profile throughput-performance -- which  has the original kernel settings , along with others.  Looking at docs  it seems that the settings in this profile do not work well with SAP products   There are profiles provided by RedHat specifically for Hana /NetWeaver / SQL server / oracle /Postgres.   Nothing for ASE/IQ/Rep Server.  So long winded question  are there any recommended settings to add/replace in the tuned profile specifically for ASE /IQ  /Replication  Server  ?  We have been working with Both SAP Support and RedHat --with no luck. 

Thanks

Jim

[tilman_model-bosch]

Dear Mr Morrison

[tilman_model-bosch]

Dear Mr Morrison I was not aware that there were issues with the above default settings (did not know the KBA you posted) . There are Linux parameter recommendations for ASE but these settings were unknown to cause issues. Ill try to follow up on this . Regards

[sladebe]

The web page:

[tilman_model-bosch · Accepted solution]

I followed up on these two parameters. 
I am still waiting for some input from colleagues but it seems that these default parameter settings apply to Redhat 8.x (not sure whether all 8x release are affected or not). Redhat 9.x seems not to be affected - have been told these parameters don't exist in 9.x.  
We also discussed whether or not to put these settings in default SAP tune configuration. As your report of this issue is the only one we are aware of, we decided to not put it to some tune configuration for now. 
But if this turns out to be a widespread issue the topic will be re-discussed again. 
HTH 

Tilman