Skip to Content

There are two tools, SAP HANA HW Configuration Check Tool (HWCCT) and Minichecks, for checking the health of SAP HANA System.

There could be more than these two tools but I want to mention about HWCCT and Minichecks in my document and give the detailed how to guides of these tools.

Notes and links that needs to be read;

1943937 – Hardware Configuration Check Tool – Central Note

Install the SAP HANA HW Configuration Check Tool

CERTIFIED SAP HANA® HARDWARE DIRECTORY

1969700 – SQL statement collection for SAP HANA

1999993 – How-To: Interpreting SAP HANA Mini Check Results

How to use Hardware Configuration Check Tool (HWCCT);

There is an attachment in note 1943937 named SAP_HANA_Hardware_Configuration_Check_Tool_1.8.pdf. You can find general info, detailed configuration and usage of the tool in this note and document.

There is a section (2.9.1 Install the SAP HANA HW Configuration Check Tool) in SAP HANA Administration Guide for the tool, too.

Below you can find the practice of this tool on our scale up HANA System.

1- Determine the right tool for your hardware

You should find your appliance on CERTIFIED SAP HANA® HARDWARE DIRECTORY and go to the details. Find your hardware’s certified scenario like the one in below picture. Then check the note 1943937 to find the right tool. Eg: “All HWCCT tests of appliances (compute servers) certified with scenario HANA-HWC-AP SU 1.1 or HANA-HWC-AP RH 1.1 must use HWCCT of SAP HANA SPS10 or higher or a related SAP HANA revision”.

HWCCT_CertScenario.jpg

2- Download the determined tool, copy to the server and install it

From swdc you can find the tool “SAP HANA HW CONFIG CHECK 1.0” under SAP HANA PLATFORM EDIT. 1.0 and download it.

Install with SAPCAR -xf HWCCT_112_xxxx.SAR

3- Prepare the test_config.json file

There are 3 test modules; Landscape Test Module, File System Test Module, NetworkTest Module.

There is a Caution for File System and NetworkTest Modules in the document that ” The test should only be used before going into production. It should only be used on production machines when this has first been requested by SAP Support”

Preperation of the json file is described in detail and templates are given for all test modules. I prepared mine like below. By checking the caution above you can use either test id 1 or all of them according to your scenarios. I also attached the json file to the document.

HWCCT_config.jpg

4- Run the tool and the result

Login to your HANADB host system

Change directory to the folder hwcct

hanaprd:/hana/shared/hwcct112 # source envprofile.sh

hanaprd:/hana/shared/hwcct112 # ./hwval -f test_config.json

And the result will be like this;

HWCCT_eval.jpg

Could be like this also;

HWCCT_eval2.jpg

How to use Minichecks

The other tool for healthcheck is Minichecks that are coming with the note 1969700 – SQL statement collection for SAP HANA as attachments.

This tool is explained in detail in the document Keeping your HANA system healthy with Mini Checks by Ronald Konijnenburg.

So I will not go into details and will just give little info about the tool.

Download the attachment SQL_Statements.zip of the note and import them into System Information tab of SAP HANA Administration Console. You can find Minicheck SQL scripts under Configuration and Minichecks folder. You should run the suitable script according to the version of your system.

HANA_Minichecks.jpg

When you run the script you will get a result like below. You should focus on the column C and the rows with  X. There is SAP note for each row. You can read and apply the notes. These notes are explained in detail in the SAP Note 1999993 – How-To: Interpreting SAP HANA Mini Check Results

HANA_Minichecks_Result.jpg

Here are some useful links;

Keeping your HANA system healthy with Mini Checks

2177604 – FAQ: SAP HANA Technical Performance Optimization Service

This is how I applied the tools.

Regards,

Yuksel AKCINAR

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Lars Breddemann

    Thanks for this really good example of how good knowledge sharing documents can look like. Well written and structured, no ‘loose end’ links or sentences and a topic that hasn’t been covered all that often so far.

    This is added benefit for the reader in a page.

    Good job!

    (0) 
  2. Mauricio Ramírez Cuevas

    Very useful information!

    Do you have more details about the CAUTION of running File System and NetworkTest Modules in production machines?

    I understand could be performance issues, but what kind of risk could be arise with the test?

    Thank you!

    (0) 
    1. Yuksel AKCINAR Post author

      Hello Mauricio,

      I did not encounter any performance effect on our 3 TB and 1 TB HANA production systems.

      Did not read any note about performance impact, either.

      Of course this does not mean that you will not encounter performance issue.

      Try to read documents and not to run scripts in peak hours.

      Regards,

      Yuksel AKCINAR

      (0) 
      1. Mauricio Ramírez Cuevas

        Hello Yuksel,

        Thank you for your feedback! I performed it too without any impact. However is good to know the behavior in more detail.

        Thank you

        (0) 
  3. Mauricio Ramírez Cuevas

    Very useful information!

    Do you have more details about the CAUTION of running File System and NetworkTest Modules in production machines?

    I understand could be performance issues, but what kind of risk could be arise with the test?

    Thank you!

    (0) 
    1. Yuksel AKCINAR Post author

      Hello Dipen,

      I have no experience about scale-out systems but there are config templates attached to the note 1943937 – Hardware Configuration Check Tool – Central Note

      You can use those templates for multinode systems.

       

      Regards,

      Yuksel AKCINAR

      (0) 
  4. Charlie Gil

    This is a great article and thank you very much.

    I have a quick question in this.

    In section 1.1, there is an expiration date of certification scenario. Can it be extended by the storage vendor or it has to be extended by SAP or it cannot even be extended once expired?

    How does it work?

    Thanks.

    (0) 

Leave a Reply