SAP Knowledge Base Article - Preview

2951899 - SAP HANA slow startup due to long rowstore load

Symptom

  1. SAP HANA Startup is slow;
  2. Load of row store tables into memory;
  3. 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

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

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.