cancel
Showing results for 
Search instead for 
Did you mean: 

Database utilization for schemas

SAPSupport
Employee
Employee
0 Kudos

We need database utilization for the last 6 months of schemas in our instance, we have referred to table "M_CS_TABLES" to fetch the history of database utilization for the last six months but we are not getting the expected output.

Could you help me or provide an SQL query to fetch the last 6-month database utilization of the schemas? or is there any standard query to fetch data from Hana Studio


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

Accepted Solutions (1)

Accepted Solutions (1)

SAPSupport
Employee
Employee
0 Kudos

Please see the sql script collection attached to
1969700 - SQL Statement Collection for SAP HANA

For example
HANA_Tables_DiskSize_2.00.060+
HANA_Tables_LargestTables_2.00.040+
HANA_Tables_TopGrowingTables_Size_History_2.00.060+

Can be edited in their "modification section" to specify the particular schema or timeframe you want to examine.

The

SAP HANA cockpit also has views for database growth:

https://help.sap.com/docs/SAP_HANA_COCKPIT/afa922439b204e9caf22c78b6b69e4f2/64861e0850f841d5a5efcb83...

Answers (0)