SAP Knowledge Base Article - Preview

3296623 - Size difference in data volume vs. data backup

Symptom

  • The size of data volume is several times larger than the size of data backup, so it is suspected that backup may not backing all the data although backup is successful without error
  • When check the following monitoring view or SQL script, there is indication of high fragmentation in data volume:
    • via view "M_DATA_VOLUME_STATISTICS", column FILL_RATIO shows low data-filled ratio, e.g. FILL_RATIO <0.7
    • via SQL: "HANA_Disks_Overview", column FRAG_PCT shows high percentage of fragmentation, .e.g FRAG_PCT >30.0


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

data volume, data backup, fragmentation, FILL_RATIO, FRAG_PCT, mnt , KBA , HAN-DB-PER , SAP HANA Database Persistence , 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.