Archive for April, 2018

List all Connected Applications to SAP HANA

 List all Connected Applications to SAP HANA
April 19, 2018 | No Comments »

You can use below SQL query to list all application connections which are connected to SAP HANA system from SQL editor.

LIST & KILL Sessions on HANA

LIST & KILL Sessions on HANA
April 17, 2018 | No Comments »

If you need to LIST all sessions or KILL a specific active session on HANA then you can use the following SQL queries to do these kind of actions easily..

Check Memory Usage and DB Size on HANA via SQL

Check Memory Usage and DB Size on HANA via SQL
April 11, 2018 | No Comments »

You can use the following SQL queries to check your HANA system’s memory usage details…

Activate / Deactivate user in SAP HANA DB

Activate / Deactivate user in SAP HANA DB
April 09, 2018 | No Comments »

The administrator can “activate / deactivate” a user account with the following SQL command or SQL console of the SAP HANA studio, the only prerequisite is, you need to have system privilege “USER ADMIN”.

CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update

CHECK_REQUIREMENTS QUEUE_NOT_EMPTY Error while SPAM Update
April 04, 2018 | No Comments »

You are trying to update your SPAM version on your SAP system and process canceled with the error CHECK_REQUIREMENTS –> QUEUE_NOT_EMPTY.In this case, you can check the below steps to clarify and solve the issue…

HANA Backup and Recovery SQL Queries

HANA Backup and Recovery SQL Queries
April 02, 2018 | No Comments »

You can find some helpful SQL queries in this article to check your HANA database backup status to use in case of recovery situation.

Blogroll