Just a small tip to help HANA administrators.

We know how to execute queries from Hana Studio, additionally there are Predefined SQL queries delivered with HANA Studio to help us with daily monitoring and HANA system analysis. These queries can be found on the tab “System Information” of HANA Studio Administration View. Double click on them and there you go…. get results in nice readable format.

H_S_02.png

Luckily there are around 194 additional queries SAP delivered with the SAP Note 1969700 – SQL statement collection for SAP HANA as zipped attachment.

H_S_01.png

What we generally do, we unzip it and open individual text files and execute them from SQL Console from studio. But we have a very handy option which helps us be more lazy and that is what we try to achieve most of the time in our basis life 😆

We can add all of the queries in one go!

From below screenshot, right click on the blank area, locate the zip file which you have downloaded from the note, and upload it.

H_S_03.png

H_S_04.png

H_S_05.png

Now you can see the entry here, you can rename it and give it meaningful name and description.

H_S_06.png

You can also delete queries, folders if they are not of your use. Drag and drop option is available to arrange it as per you mood.

H_S_08.png

Now the important part, How to save it? two options, click on the log-off option from Hana studio or close the administrative view; in both cases it will prompt you to save the changes. Do not panic you can save it. Later if you need you can delete entire folder.

H_S_10.png

Next time whenever you’ll login to this system, you’ll find those nice set of queries waiting for you to execute.

Related SAP Notes and references

1969700 – SQL statement collection for SAP HANA

1999993 – SAP HANA Mini Checks

Execute SQL Statements in SAP HANA Studio – SAP HANA Administration Guide – SAP Library

The SAP Hana Reference for SAP Basis Administrators

http://help.sap.com/hana/sap_hana_sql_script_reference_en.pdf


To report this post you need to login first.

2 Comments

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

  1. Lars Breddemann

    Nice write up about a handy feature.

    Not too sure about the extensive list of your blog posts at the end. I would propose you let the readers look for your content via your profile-content list, when they are interested.

    Please be also careful with the choice of tags. Words like ‘the’ or ‘little’ simply don’t add anything but clutter and won’t get your blog a better rating in the search engines. Make sure to add tags that _add_ something to your blog posts that is not already in there.

    Otherwise: thanks again 🙂 I like this kind of experienced-based writing a lot!

    Cheers,

    Lars

    (0) 

Leave a Reply