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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.