Symptom
You notice SAP HANA taking longer to start. In indexserver traces, you can see entries similar to the following:
[437755]{-1}[-1/-1] 2021-05-15 18:33:12.131692 i MidSizeLobContai LOBFileIDMapping.cpp(00161) : Starting 112 threads (lob_fileid_mapping_parallel_load_count) to load file ID mappings into lobFileIDMap, lobFileIDBackMap, eidMap and ownerBackMap with 224 stripes each (lob_fileid_mapping_stripe_count), stripeFactor 28 for eidMap and ownerBackMap (lob_fileid_eid_mapping_stripe_factor).
[440414]{-1}[-1/-1] 2021-05-15 18:33:17.740385 i MidSizeLobContai LOBFileIDMapping.cpp(00355) : Producer[108] processed 794831 file ID mappings in 5.16557 seconds.
...
[440337]{-1}[-1/-1] 2021-05-15 18:33:25.143249 i MidSizeLobContai LOBFileIDMapping.cpp(00355) : Producer[97] processed 796987 file ID mappings in 12.6617 seconds.
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.636023 i MidSizeLobContai LOBFileIDMapping.cpp(00216) : Loading 88940331 file ID mappings finished in 20.5678 seconds.
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.636055 i PersistenceManag PersistentSpaceImpl.cpp(01510) : loadContainerDirectories - done.
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.636064 i PersistenceManag PersistenceManagerImpl.cpp(02309) : PersistenceManager::setState(ReadyForRestart)
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.636075 i PMRestart PersistenceSessionRegistry.cpp(00329) : Initialize transient structures
[444115]{-1}[-1/-1] 2021-05-15 18:33:30.641438 i PMRestart VirtualFileStatsProxy.cpp(00306) : Initialize LOB owner statistics from VirtualFiles...
[440351]{-1}[-1/-1] 2021-05-15 18:33:30.641454 i PMRestart VirtualFileStatsProxy.cpp(00215) : Initialize VirtualFile statistics...
[437755]{-1}[-1/-1] 2021-05-15 18:33:30.642467 i ContainerDirecto ContainerNameDirectoryImpl.cpp(01440) : Load ContainerNameDirectory...
[440849]{-1}[-1/-1] 2021-05-15 18:33:30.642468 i PMRestart VirtualFileStatsProxy.cpp(00371) : Initialize LOB owner statistics from MidSizeLob...
[440849]{-1}[-1/-1] 2021-05-15 18:33:30.649728 i PMRestart VirtualFileStatsProxy.cpp(00427) : LOB owner statistics initialized from MidSizeLob: 213 CD entries in 7.25 msec
[440351]{-1}[-1/-1] 2021-05-15 18:33:31.564489 i PMRestart VirtualFileStatsProxy.cpp(00282) : VirtualFile statistics initialized: 63100/63100 CD entries in 923.02 msec
[437755]{-1}[-1/-1] 2021-05-15 18:33:32.336785 i ContainerDirecto ContainerNameDirectoryImpl.cpp(01464) : ContainerNameDirectory loaded 192587/192587 in 1.69 sec
[444115]{-1}[-1/-1] 2021-05-15 18:45:08.326197 i PMRestart VirtualFileStatsProxy.cpp(00351) : LOB owner statistics initialized from VirtualFile: 136345778 CD entries in 11.63 min
Read more...
Environment
SAP HANA, platform edition
Product
SAP HANA, platform edition 2.0
Keywords
slow, startup, hanging, taking longer, not starting, started, poor, performance , KBA , HAN-DB-PER , SAP HANA Database Persistence , Problem
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.