3054023 - Monitoring hana/data volume growth

Symptom

The hana/data persistence volume(s) is continually growing/nearing full capacity and you would like to resolve the root cause of the growth.

 

Environment

  • SAP HANA PLATFORM EDITION 1.0
  • SAP HANA PLATFORM EDITION 2.0

Cause

The growth on hana/data typically comes from rapidly growing large tables or free unclaimed data pages on the disk.

It can also be the case that the table's new size on disk has not been updated yet since the latest delta merge and optimize compression to write the new changes to main storage.

Nevertheless, analysis and investigation should still be carried out to determine the root cause.

 

Resolution

  • To get a detailed overview of the current data volume consumption, execute the output of these scripts from your sql console on your HANA Studio, HANA Cockpit or DBACOCKPIT interface 
     
    HANA_Disks_Data_Overview_*
    HANA_Disks_Overview_*
    HANA_Disks_Data_Pages_*
    HANA_Configuration_MiniChecks_* (Any disk or persistence related alerts marked with an 'X' can be checked against KBA 1999993 - How-To: Interpreting SAP HANA Mini Check Results)

           (To access these scripts, please navigate to the SQLstatements.zip folder at the bottom of Note 1969700)

  

  • The "HANA_Disks_Data_Overview" is the most important query to use first , in orderto identify the actual problem area for current disk space consumption.

    [OUTPUT PARAMETERS] section lists the description of the different information metrics of each column

    - HOST:         Host name
    - PORT:         Port
    - ALLOC_GB:     Allocated data size (GB)
    - USED_GB:      Used data size (GB)
    - COLTAB_GB:    Size of column store tables + indexes (GB)
    - ROWTAB_GB:    Size of row store tables + indexes (GB)
    - FLOB_GB:      Size of classic file disk LOBs (GB)
    - PLOB_GB:      Size of packed disk LOBs (GB)
    - HISTORY_GB:   Size of undo and cleanup files (GB)
    - SHADOW_GB:    Size of shadow pages (GB)
    - LIVECACHE_GB: Size of liveCache pages (GB)
    - DOCSTORE_GB:  Size of docstore (GB)
    - OTHER_GB:     Size of other areas (GB)


    [EXAMPLE OUTPUT]

    -------------------------------------------------------------------------------------------------------------------
    |HOST     |PORT |ALLOC_GB  |USED_GB   |COLTAB_GB|ROWTAB_GB|LOB_GB   |HISTORY_GB|SHADOW_GB |LIVECACHE_GB|OTHER_GB  |
    -------------------------------------------------------------------------------------------------------------------
    |hana00600|36003|   2962.37|   2674.26|  1518.28|     0.00|     0.00|      0.05|      0.01|        0.00|   1155.91|
    |hana00800|36003|   3105.25|   2664.80|  1656.63|     0.00|     0.00|      0.10|      0.01|        0.00|   1008.04|

     

  

  • For the Columnstore, rowstore and File/Packed LOB tables under headings :

    COLTAB_GB
    ROWTAB_GB
    FLOB_GB 
    PLOB_GB 


    1. Please use the table statistics script checks here for a detailed overview and sort the largest tables by descending size in use
      
      HANA_Tables_DiskSize_*
      HANA_Tables_LargestTables_*
      HANA_Tables_TopGrowingTables_Size_History_*
      HANA_LOBs_DiskLOBs_
      HANA_LOBs_LOBFiles_


    2. First check if regular housekeeping or data archiving can be performed to reduce the total record size of the problem table with KBA 2388483 - How-To: Data Management for Technical Tables.
        Using DBTABLOG table as an example, the SAP Note / reference & Details sections provide the Note numbers & tools and reports that can be used on the application level for these cleanup tasks


    Tables Product / Stack Area SAP Note / reference Details

    DBTABLOG, DBTABPRT

    		 ABAP table logging

    2335014
    2362854

    transaction SCU3, report RSTBPDEL
    report S_AUT_ARCH_STXL_CLEAN (orphan STXL entries)

     

  • Data consumed under the other common consumer metrics have accompanying documentation :

    HISTORY_GB   : 3361119 - high disk usage under HISTORY_GB area
    OTHER_GB      : 2815538 - High disk consumption reported under OTHER_GB
    SHADOW_GB  : 3278379 - Shadow pages consuming the data volume on HANA

        

 

  • The most common reasons for hana/data file system utilization are generally covered in the following HANA knowledge articles :
       
        2910857 - Increase Data Volume free space
        2937935 - High disk usage on SAP HANA Data volume caused by technical tables
        2562939 - HANA Data Volume Used Size is Doubled or Much Larger than Before
        2499913 - How to shrink SAP HANA Data Volume size
        2348397 - Shrink the Data Volume on Secondary Site with SAP HANA System Replication
        1910140 - How to Handle Alert 20 ‘Table growth of non-partitioned column-store tables’
        2815538 - High disk consumption reported under OTHER_GB
        2910794 - Datavolume size started to grow

  • It is common that the expected reduction and reclaim of allocated space both in memory and on disk will not occur immediately upon client archiving.
    This is explained in the following documents with steps to take in these scenarios :

       3028886 - Table size on disk does not decrease after data archiving
       2731449 - After table deletion and successful Delta Merge, table size Is not decreased
       3425015 - Data volume size and memory size is not reduced after client delete
       3209719 - Data file size is not reduced after data deletion.
       3194175 - How to reduce table disk size

     

  • Further LOB table cleanup and reclaim operations are explained in : 3195436  - Analyze high disk utilization in HANA Database

Remark :

'*' indicates the revision of the script closest to your current revision of HANA  i.e 'HANA_Disks_Data_Overview_2.00.030+'

See Also

Persistent Data Storage in the SAP HANA Database > Data and Log Volumes

Keywords

Database grows, Total disk usage for /hana/data is high, Disk Size increased suddenly, HANA DB is growing, database file system utilization, /hana/data Full, persistence full, data volume full, FS /hana/data is full, Abnormal Data Growth, Abnormal DB growth, /hana/data Filesystem is full, /Hana/Data increased, /hana/data is 100% full, /hana/data is filling up, /hana/data is getting occupied, /hana/data mountpoint has increased , /hana/data/ occupied, Database growth, Database size is full, Disk Fragmentation, disk of hana server is full, Disk reduction in HANA, Disk size is not reducing, Disk Size not reducing after Table cleanup, Disk space utilization increased suddenly, Hana Database disk size is increasing, HANA DB Size increasing continuously, Huge datfile, Huge DB growth, Unexpected growth, Unnecessary disk consumption, unused space in db, Unusual database growth

posted on 2025-09-20 08:21  BASIS/老应  阅读(5)  评论(0)    收藏  举报

导航