houzuoguo / saptune

Comprehensive system tuning management for SAP solutions

saptune

The utility adjusts system parameters such as kernel parameters and resource limits to allow running various SAP solutions at satisfactory performance. The utility is first made available on SP2 release of SLES4SAP 12, and it can be used in place of sapconf. The utility is not yet officially released for ordinary SLES, though it may also function on SLES.

RPM package

You may find a ready-made RPM spec file at https://build.opensuse.org/package/show/SUSE:SLE-12-SP2:GA/saptune

saptune's Issues

Summary of issues from SLES 15

• Page cache limit fails to be set (1557506).
• UUID daemon socket can be manually started and stopped, however saptune fails to control it (1984787).
• noop is not a valid block IO scheduler in a KVM guest (2161991, ASE).
• net.ipv4.tcp_tw_recycle is not present (SUSE-GUIDE-02).

saptune and customer-specific customizations

I'm trying to understand some issues with saptune on SLES12SP3 where /etc/security/limits.conf are apparently getting reset to default values of 32800 even after specific values are set. I'm trying to figure out a way to see how I can track these changes. System auditing at this point seems to be the best idea.

I started examining the code and wondered about hard-coded values like the ones seen below:

81 // Raise maximum file descriptors to at least 32800
82 for _, val := range []*system.SecurityLimitInt{&newPrepare.LimitNofileSapsysSoft, &newPrepare.LimitNofileSapsysHard, &newPrepare.LimitNofileSdbaSoft, &newPrepare.LimitNofileSdba Hard, &newPrepare.LimitNofileDbaSoft, &newPrepare.LimitNofileDbaHard} {
83 switch *val {
84 case system.SecurityLimitUnlimitedValue:
85 // nothing to do, value remain untouched
86 default:
87 if *val < 32800 {
88 *val = 32800
89 }
90 }
91 }

Would it not make sense to have these sorts of hard-coded values (and others) in some sort of table, external to saptune so that changes could be made without recompiling the program? It almost seems like a 'meta' solution or note would make this more flexible in the long term.

I admit that I don't know much about the design but I found it curious and was just trying to understand some more.

Consider displaying optimisation details in program output during their application

Although users are advised to run simulation or verification subcommand prior to applying an optimisation, it may still be useful to show the optimisation actions in detail while they are applied.