SAP Knowledge Base Article - Preview

3462540 - HANA DB complete data backup running for a long time due to I/O performance

Symptom

You observe a HANA complete data backup running for several hours.

Reviewing the indexserver traces shows a small value for minSendThroughput:

[22006]{-1}[67/2226124280] 2024-03-18 18:35:33.629140 i PersistenceManag PersistenceManagerImpl.cpp(07341) : BackupChannel: create backup 491418 - 0, redo log position = 489051806083
...
minReceiveThroughput=1733.37MB/s, maxReceiveThroughput=1733.37MB/s, avgReceiveThroughput=1733.37MB/s, avgReceiveThroughputUnbiased=1817.57MB/s, receiveCount=1
minSendThroughput=2.15MB/smaxSendThroughput=2.15MB/s, avgSendThroughput=2.15MB/s, avgSendThroughputUnbiased=2.25MB/s, sendCount=1
...
 Stream::SynchronousPoolCopyHandler::triggerReceiveAndSend(Stream::SynchronousPoolCopyBuffer*, Stream::SynchronousPoolCopyBuffer*)(17usec)
[15985]{-1}[-1/-1] 2024-03-19 23:30:56.881222 a Multistream      SynchronousPoolCopyBuffer.cpp(00057) : Enter bool Stream::SynchronousPoolCopyBuffer::handleStreamDataCallback(size_t, bool)
...
[17483]{-1}[-1/-1] 2024-03-19 23:45:59.723616 i Multistream      SynchronousPoolCopyHandler.cpp(00661) : transferPendingSize=0, copyTimeUs=2861770
minReceiveThroughput=1149.03MB/s, maxReceiveThroughput=1149.03MB/s, avgReceiveThroughput=1149.03MB/s, avgReceiveThroughputUnbiased=1204.84MB/s, receiveCount=1
minSendThroughput=2.16MB/smaxSendThroughput=2.16MB/s, avgSendThroughput=2.16MB/s, avgSendThroughputUnbiased=2.27MB/s, sendCount=1

Executing the SQL query mentioned in 7(a) of SAP Note 1835075, you observe that Write Throughput in MB is lower than expected:

;RESET_TIME;HOST        ;PORT  ;SERVICE_NAME;TYPE          ;Read in MB   ;Read Throughput in MB;Read Time in Sec;Read Ratio             ;Write in MB;Write Throughput in MB;Write Time in Sec;Write Ratio              
;?         ;<hostname> ;30,003;indexserver ;DATA_BACKUP   ;0            ;0                    ;0               ;0                      ;101,376.152;2.519                 ;42,200.944       ;0.00000003285630708102527


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

Backup, recovery and performance issue, minSendThroughput , KBA , HAN-DB-BAC , SAP HANA Backup & Recovery , 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.