Solution : https://service.sap.com/sap/support/notes/1127881 (SAP Service marketplace login required)
Summary :
This SAP Note addresses a performance issue where the system often waits for the "hash mutex" of the "sysdistrib" table due to missing parameter recommendations from 2004 affecting the optimizer statistics. To resolve this, adjust the DS_HASHSIZE and DS_POOLSIZE settings according to specifications outlined in SAP Note 41360. Implement these changes to prevent bottlenecks, even if no immediate issues are evident.
Key words :
general performance problem, system frequently waits, special cache exists, ds_poolsize 2000ds_hashsize 503implement, hash mutex, terms - reason, infcfgcheck check, bottleneck occurs, optimizer statistics, 41360 database configuration
Related Notes :
41360 | Database configuration using onconfig parameter |