Need HANA SQL Query for CPU & DISK Size

[Former Member]

Hi ALL,

I am looking for SAP HANA sql query to get the Total CPU usage ( data base usage + os leve cpu usage) and

also for the Total disk size & disk usage.

Thanks

Ravi

[Former Member]

Hi Ravi

The two queries below, which are attached to SAP Note 1969700 (SQL statement collection for SAP HANA) will return the following details:

HANA_Resources_CPUAndMemory_History.txt (please ensure to run the query specific to your HANA revision):
- SNAPSHOT_TIME:    Time of snapshot
- HOST:             Host name
- PHYS_TOTAL_GB:    Total memory on host
- PHYS_USED_GB:     Overall memory used on host
- PHYS_USED_PCT:    Percentage of memory used on host
- ALLOC_LIM_GB:     Allocation limit (GB)
- HANA_ALLOC_GB:    Memory allocated by SAP HANA database (GB)
- HANA_USED_GB:     Memory used by SAP HANA database (GB)
- HANA_USED_PCT:    Percentage of allocation limit used
- SWAP_FREE_GB:     Amount of free swap space (in GB)
- SWAP_USED_GB:     Amount of used swap space (in GB)
- CPU_BUSY_PCT:     Percentage of busy CPUs (user + system)
- CPU_USER:         Average number of CPUs busy with user activities
- CPU_SYS:          Average number of CPUs busy with system activities
- CPU_IOWAIT:       Average number of CPUs waiting for I/O
- CPU_IDLE:         Average number of CPUs being idle

HANA_Hosts_Disks.txt:
- HOST:          Host name
- DEVICE_ID:     Device ID
- USAGE_TYPE:    Usage type (e.g. DATA, LOG)
- PATH:          Directory path
- FILESYSTEM:    Filesystem type
- TOTAL_SIZE_GB: Total disk size (GB)
- USED_SIZE_GB:  Used disk size (GB)
- USED_PCT:      Percentage of available disk size used

Ruth

[mathanponnucham]

Dear Ravi,

SAP HANA Host resource utilization table “HOST_RESOURCE_UTILIZATION_STATISTICS” contains information for the last 42 days. Please do execute SQL select statement as per your requirement.

Rgds,

Mat.

[sadanand_bhat]

Check the attached zip file in the Note 1969700. This contains a collection of all the SQL queries you need!

--

saddy