How to find the hardware information of the Installed HANA Database using studio tool ??

[Former Member]

Hi SAP HANA Experts,

How can we find the Hardware Information of the HANA Database using the Studio tool.

I mean, i want to find out the Hardware Information like CPU Model Number, RAM Size & HDD. { HANA Database is already installed as a standalone system } using the Studio tool.

Can any one of you please provide me the different possibilities to get the Hardware information.....

[mathanponnucham · Accepted solution]

Hello,

Try running the below SQL script in your HANA database. The output should have the info you havd been looking for.

-----------------------------------

SELECT

/*

[NAME]

- HANA_Hosts_Overview

[DESCRIPTION]

- Host information

[DETAILS AND RESTRICTIONS]

[VALID FOR]

- Revisions:              all

- Statistics server type: all

[SQL COMMAND VERSION]

- 2014/05/30:  1.0 (initial version)

[INVOLVED TABLES]

- M_HOST_INFORMATION

[INPUT PARAMETERS]

- HOST

  Host name

  'saphana01'     --> Specific host saphana01

  'saphana%'      --> All hosts starting with saphana

  '%'             --> All hosts

[OUTPUT PARAMETERS]

- HOST:           Host name

- BUILT_BY:       Manufacturer name

- CPU_DETAILS:    CPU details (cores, threads, speed)

- PHYS_MEM_GB:    Physical memory size (GB)

- SWAP_GB:        Swap size (GB)

- OP_SYS:         Operating system type and version

- HARDWARE_MODEL: Hardware model

- CPU_MODEL:      CPU model

[EXAMPLE OUTPUT]

----------------------------------------------------------------------------------------------------------------------------------------------

|HOST     |MANUFACTURER|ACTIVE|CPU_DETAILS       |PHYS_MEM_GB|SWAP_GB|SEC_STORE|OPERATING_SYSTEM                 |HARDWARE_MODEL             |

----------------------------------------------------------------------------------------------------------------------------------------------

|saphana20|IBM         |yes   |80 (160) * 2395MHz|    4039.88|  32.00|available|SUSE Linux Enterprise Server 11.2|System x3950 X5 -[7143HDG]-|

|saphana21|IBM         |yes   |80 (160) * 2395MHz|    4039.88|  32.00|available|SUSE Linux Enterprise Server 11.2|System x3950 X5 -[7143HDG]-|

----------------------------------------------------------------------------------------------------------------------------------------------

*/

  H.HOST,

  MAX(CASE WHEN KEY = 'hw_manufacturer' THEN VALUE END) BUILT_BY,

  MAX(CASE WHEN KEY = 'cpu_summary' THEN VALUE END) CPU_DETAILS,

  LPAD(MAX(CASE WHEN KEY = 'mem_phys' THEN TO_DECIMAL(TO_NUMBER(VALUE) / 1024 / 1024 / 1024, 10, 2) END), 11) PHYS_MEM_GB,

  LPAD(MAX(CASE WHEN KEY = 'mem_swap' THEN TO_DECIMAL(TO_NUMBER(VALUE) / 1024 / 1024 / 1024, 10, 2) END), 7) SWAP_GB,

  REPLACE(MAX(CASE WHEN KEY = 'os_name' THEN VALUE END), 'SUSE Linux Enterprise Server', 'SLES') OP_SYS,

  REPLACE(MAX(CASE WHEN KEY = 'cpu_model' THEN VALUE END), '(R)', '') CPU_MODEL,

  MAX(CASE WHEN KEY = 'hw_model' THEN VALUE END) HARDWARE_MODEL

FROM

( SELECT                  /* Modification section */

    '%' HOST

  FROM

    DUMMY

) BI,

  M_HOST_INFORMATION H

WHERE

  H.HOST LIKE BI.HOST

GROUP BY

  H.HOST

ORDER BY

  H.HOST

----------------

Rgds,

Mat.

[Former Member · Accepted solution]

Thanks a Loooooooooooooooooooooooootttttttttttttttttttttttttttttttttttttt.

I got the information..........................

[Former Member · Accepted solution]

Hi Mathan,

Can you please tell me among the following listed processors, which one will be provides the better performance for SAP HANA Database.....

1. Intel Xeon E5 2630 v3 2.4 Ghz; 8 Cores, 16 Threads ; Turbo boost up-to 3.2 Ghz

2. Intel Xeon CPU X 5570 2.9Ghz; 4 Cores, 8 Threads; Turbo boost up-to 3.3 Ghz

------------------------

[mathanponnucham · Accepted solution]

Hello,

Certified SAP HANA appliance list can be found in the link below.

Certified SAP HANA® Hardware Directory

Sorry HANA is delivered as an appliance (CPU, memory, N/W, etc), hence we cannot make a judgement based only upon CPU. Choice of SAP HANA appliance also depends on which SAP system (BW or SoH or EDW) do you want to deploy in the HANA DB.

Regards,

Mat.

[Former Member]

Hello,

Please use the HANA_Hosts_* scripts found in the attachment of OSS note 1969700.

Kind Regards,

Amerjit