HANA DB checks

Sometimes its necessary to carry out in-depth database checks. According to best practice, SAP also recommends running some of these SQL-script regularly, e.g. after HANA DB updates.

SQL Scripts I want to explain in detail:

• SAP HANA parameter recommendations

• SAP HANA Mini Checks

... and there are many more.

All those small SQL-scripts were written by a former SAP employee named Martin Frauendorfer.

If you have any questions about the scripts: [e-mail]

Link to the SQL Statement Collection: https://launchpad.support.sap.com/#/notes/1969700

The scripts can be started by all applications that have a functioning SQL interface, including

• SAP HANA Cockpit

• SAP HANA Studio

• DBA Cockpit

on premise & cloud-based

How to use the scripts?

First you need to download preferably the hole Statement Collection. Use the link from above and download to your local computer:

In HANA Studio

Import the zipped collection (do NOT unzip, it's not necessary)

Create a new folder

Import statements into new folder

Now you can already run the script. Be careful on what script you're executing, and never first-try in productive system!

In our case we want to use the HANA MiniCheck script.

If we want to make a selection or set filters, we can also edit the file with clicking "Open in SQL Console" (e.g. only specific timeframe wanted)

-> Execute

The result can be saved to your local machine as a "delimited text file".

In Excel we now want to import the test results:

-> Klick from Text/CSV

Check the preview window, if it looks like mine below, then klick load. Otherwise you need to transform data first with clicking "Daten transformieren". Set delimiter "semicolon", also set "first line as header" and then transform again.