SAP Knowledge Base Article - Preview

2467545 - Wrong SAP HANA I/O parameter settings

Symptom

When running HANA_Configuration_MiniCheck attached to note 1969700 you are getting alert for:

 Wrong SAP HANA I/O parameter settings          ;        ;yes                      ;no            ;X; 1930979

However when checking trigger ratio as per SAP Note 1930979 TRIGGER_WRITE_RATIO and TRIGGER_READ_RATIO is below or equal 0.5 in all rows.

Checking for I/O by running HANA_IO_KeyFigures_Total.txt attached to note 1969700 shows no performance data for DATA_BACKUP and LOG_BACKUP:

;HOST;PORT ;IO_TYPE    ;FILESYSTEM;READ_GB     ;AVG_READ_SIZE_KB;READ_TIME_S;AVG_READ_TIME_MS;READ_MB_PER_S;TRIG_READ;WRITE_GB     ;AVG_WRT_SIZE_KB;WRITE_TIME_S;AVG_WRT_TIME_MS;WRITE_MB_PER_S;TRIG_WRITE;FAILED_READS;FAILED_WRITES;CONFIGURATION
1;any ;  %03;DATA_BACKUP;any       ;        0.00;               0;          0;               0;         0.00;     0.00;         0.00;              0;           0;              0;          0.00;      0.00;           0;            0;any         
2;any ;  %03;LOG_BACKUP ;any       ;        0.00;               0;          0;               0;         0.00;     0.00;         0.00;              0;           0;              0;          0.00;      0.00;           0;            0;any         
3;any ;  %03;LOG        ;any       ;       10.65;        15279.49;         10;           13.48;      1106.62;     0.00;        10.65;           4.93;         676;           0.29;         16.15;      0.01;           0;            0;any         
4;any ;  %03;DATA       ;any       ;      319.73;          238.89;       1470;            1.04;       222.79;     0.00;       195.28;          84.15;         532;           0.21;        376.08;      0.00;           0;            0;any


Read more...

Environment

  • SAP HANA 122.04 and higher
  • Backups are running via BACKINT.

Product

SAP HANA 1.0, platform edition

Keywords

BACKINT TRIGGER_WRITE_RATIO TRIGGER_READ_RATIO HANA_IO_KeyFigures_Details , KBA , HAN-DB , SAP HANA Database , 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.