Symptom
- SAP HANA Startup is slow;
- Load of row store tables into memory;
- In the indexserver trace, there are the following information messages:
Service_Startup SharedMemoryUtil.cc(02332) : Loading RowStore segments from Persistency
Service_Startup CheckpointMgr.cc(00768) : fast restart: false
RowStorePageAcce AbsolutePageAccessImpl.cpp(01181) : loadMultiplePageBlocksAtStartup
RowStorePageAcce AbsolutePageAccessImpl.cpp(01196) : allocate 8436 segments requested to load and collect information about superblocks to read...
RowStorePageAcce AbsolutePageAccessImpl.cpp(01351) : collecting information done in 729089msec.
RowStorePageAcce AbsolutePageAccessImpl.cpp(01382) : SuperblockPrefetchCalculation: allocationLimit=5648300755048/ inUseSize=291763586354/ prefetchSize=6695671460867/ prefetchCount=99773
RowStorePageAcce AbsolutePageAccessImpl.cpp(02139) : set SuperblockPrefetchCount=32767 (max: 32767)
RowStorePageAcce AbsolutePageAccessImpl.cpp(01388) : trigger load of superblocks...
RowStorePageAcce AbsolutePageAccessImpl.cpp(02015) : load process: 0% (1 of 8441) : overall 388MB/s.
RowStorePageAcce AbsolutePageAccessImpl.cpp(01475) : trigger load of superblocks done after 5752msec.
RowStorePageAcce AbsolutePageAccessImpl.cpp(02034) : i/o finished: read 8441 superblock(s) within 496536ms = 1087MB/s overall.
RowStorePageAcce AbsolutePageAccessImpl.cpp(01491) : finished loading all 8436 segments by reading 8441 superblocks after 1225629msec.
Service_Startup CheckpointMgr.cc(00960) : - RS segment loading progress: 10% done
Service_Startup CheckpointMgr.cc(00835) : 8436 RS segments loaded from Persistency in 1267.34 sec (426.01MB/s)
Read more...
Environment
- SAP HANA, platform edition 1.0
- SAP HANA, platform edition 2.0
Product
Keywords
row, store, stored, load, loading, inmemory, memory, start, restart, restarting, performance, long, initialization, initializing , KBA , HAN-DB , SAP HANA Database , HAN-DB-ENG , SAP HANA DB Engines , 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.
SAP Knowledge Base Article - Preview