SAP HANA DISK ISSUE

[arun_kumar165]

Hi Team,

In our Hana System Disk used size is Showing 1.2 TB ,But when I retrieved row store and column table .It is coming around  650 GB .I have used the SAP Script which is provide in the SAP NOTE.I have attached the Script and DB02 Screen for evaluation. Is there any script where I can get all details about the data stored in Data to evaluate 1.2 TB.

Thanks,

Arunkumar

HANA_Tables_DiskSize.txt.zip

[Former Member]

Hi Arun,

It is not mandatory that 1.2TB should be equal to Rowstore+Coloumnstore Size. There might be a chance that disk is more fragmented.

As mentioned by Ning, you can first identify the individual row store & coloumn store sizes.

If you want to make the Disk size equals to row store +column store , then you need to go for defragmentation of disk. 

Regards,

Pavan Gunda

[davidebruno]

I think you can proceed with a row store reorganization

1813245 - SAP HANA DB Row store reorganization

[former_member182967]

Hi Arun,

Can you follow note https://launchpad.support.sap.com/#/notes/1870858 to check the volume size and disk usage for data volumes.

Regards,

Ning

[yakcinar]

Hello Arun,

There should be column tables not loaded into memory.

Check those tables.

Regards,

Yuksel AKCINAR

[former_member183326]

Go to Note 1969700 and use the memory overview query.

This should give you a good idea