SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




CRM Companies List
Web Based CRM Software


Check HANA Database Table Size using HANA Studio


SAP HANA database administrator or SQLScript developers can use SAP HANA Studio to check database table sizes on disk to see how much disk space each SAP table uses. Disk space used by each SAP table can be viewed by using HANA Studio Administration cockpit visually or using SQL Console by querying M_TABLE_PERSISTENCE_STATISTICS monitoring table.

Using SAP HANA Development perspective, using Systems tab find your SAP HANA database system from the list.

SAP HANA Studio HANA Development perspective

Right click on the target SAP HANA database using System window in SAP HANA Studio
Using the context menu, follow options Configuration and Monitoring > Open Administration

launch Administration tools for HANA database using SAP HANA Studio

Administration cockpit will provide SAP HANA Studio users a huge amount of data about the HANA database that the SAP system is running on.

Switch to System Information tab.
A list tools or HANA database applications will be listed as in below screenshot.
SAP HANA Studio users can use the Size of Tables on Disk tool which enables developers to see the size of HANA database tables on disk in bytes.

SAP HANA Studio tools for database System Information

Double click on the Size of Tables on Disk tool for default use.

Using Add filter button, SAP HANA Studio users can addd filters like table disk size, table name or schema name to minimize the list of tables you are dealing with on the return list.

add filter

The filter criteria will be visible on the Filters section.

add filter for database table list

When you run the query to list the SAP HANA database tables and their disk sizes, a result set similar to below will be displayed. Please note that the size column value is in bytes.

SAP HANA database table size

Of course, if you are an experienced SQL programmer it is an option to type your query for additional information on the System Information tool.
On the Administration cockpit, instead of double click on the "Size of Tables on Disk" or Execute the tool immediately, right click on from context menu choose

SQL console for SQLScript query

Here is the default SQLScript query for displaying SAP HANA database table sizes on disks
Of course, SQL developer can use other fields from M_TABLE_PERSISTENCE_STATISTICS like page_count, read_count, write_count, bytes_read, etc. by modifying your SQL query

SELECT
 SCHEMA_NAME,TABLE_NAME,DISK_SIZE
FROM
 PUBLIC.M_TABLE_PERSISTENCE_STATISTICS
ORDER BY
 DISK_SIZE DESC

SQL query for SAP HANA database table size on disk






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems