Solution : https://service.sap.com/sap/support/notes/1555955 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance issues in SAP Solution Manager 7.1 SP01 and higher when interacting with the Landscape Management Database (LMDB). Users experiencing long response times may find that this is due to the exhaustion of server shared memory, forcing work processes to access database tables directly, prominently LMDB_P_CLASS. This is visible within TCode SM50 or SM66. A second performance issue arises when outdated Oracle database statistics slow down the initial synchronization of SLD to LMDB content, leading to increased costs for full table scans by the Cost Based Optimizer. Solutions include ensuring adequate shared memory allocation and updating Oracle database statistics periodically, particularly after starting content synchronization. Detailed guidance and links to resources for managing these settings are provided.
Key words :
lmdb_p_assoc associations lmdb_p_changelog change log lmdb_p_class cim classes lmdb_p_guid guids, /instguides installation & upgrade guides -> sap components -> sap solution manager -> release 7, storage lmdb_p_namespace cim namespaces lmdb_p_pq_names hashvalues, names lmdb_p_qualifier cim qualifier declarations, /saphelp_nw70ehp2/helpdata/en/88/fce73a86e99c77e10000000a114084/frameset, terms sld content synchronization reason, setup guide landsape management database, initial sld->lmdb content synchronization, sap solution manager system, instance references lmdb_p_long_val long
Related Notes :
| 1669645 | Kein Fortschritt bei der inkrementellen LMDB Synchronization |
| 1594654 | LMDB Content Sync: Performance and Reference Numbers |
| 1582842 | Profile parameters for Solution Manager 7.1 |