Skip to Content
author's profile photo Welly Sunarko
1
Welly Sunarko

How to find the cause of HANA DB disk usage increase ?

Posted on Jun 20, 2019 at 01:39 AM 488 Views

HANA DB "DISK USED DATA" jumped by 12 GB. How can I find out what the cause of this jump ?
HANA Version:2.00.030.00.1522209842
Build:28.03.2018 06:35:01

Thank you

dailytask2019-06-20-11-35-41-db-size-history.jpg (518.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Dennis Padia
    Dennis Padia
    Posted on Jun 20, 2019 at 03:51 AM
    2

    Hello Welly,

    You can run "HANA_Tables_TopGrowingTables_Size_History_2.00.000+" from SAP Note 1969700.

    You can modify values in below section of SQL statement like BEGIN_TIME, END_TIME and SCHEMA_NAME.

    Once the table is been identified, you can get information on where this table is been used and have word with your application team if there was any new roll out.

    Regards,

    Dennis


    24.jpg (43.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.