Small Tip: (HANA Studio) Enrich your monitoring moments
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.
Luckily there are around 194 additional queries SAP delivered with the SAP Note 1969700 – SQL statement collection for SAP HANA as zipped attachment.
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.
Now you can see the entry here, you can rename it and give it meaningful name and description.
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.
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.
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
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
Thanks Lars for the suggestion, I have removed the list of my previous blogs.
Hello Colleagues,
Is there a way to save the query results on the server disk as a Log ?