Global DATA disk size and sum of tables disk size

[selim_derouiche]

Hello,

When I check the disk space used by HANA Database data I find about 2.5To

SELECT USED_SIZE from SYS.M_DISKS where USAGE_TYPE='DATA'

When I check the sum of disk space used unitary by all tables I don't find those 2,5To :

select sum(disk_size) from M_TABLE_PERSISTENCE_STATISTICS

• => 1,5 To

select sum(table_size) from m_tables

• => 1,2 To

I suppose that 'DATA' disk space is used by tables data so the sum of tables size on disk should be near to this value.

Where Can I find unitary tables size (which system view and column) whith a sum equals or near to DATA used size (M_DISKS.USED_SIZE) ?

Platform : SUSE Linux Enterprise Server 12 SP5

Version : 2.00.052.00.1599235305 (fa/hana2sp05)

thanks,

[simon25]

Hi Selim,

2.5TB is used in total vs 1.5 TB used by the actual tables from what I understand ?

You may have other underlying issues like high fragmentation, free data pages remaining unclaimed, orphan disk LOBs etc eating up allocated space.

These script checks are useful tools for getting detailed statistics for what is consuming your persistence volumes under the hana/data area :

"HANA_Disks_Overview"

"HANA_Disks_Data_Overview"

"HANA_Disks_Data_Pages"

"HANA_Tables_DiskSize"

"HANA_Configuration_MiniChecks" will alert to any critical issues with the disk area too.

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

Kind Regards

Simon