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

Search for additional results

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