cancel
Showing results for 
Search instead for 
Did you mean: 

what is SAP HANA Test plan and regular check list

Former Member
0 Kudos

Hi Experts,

I am working on SAP HANA Administrator.

I Have some issues.

  1. Can we generate report or query   on SAP HANA usages. like per day total user connected to Hana , how many query are ran per day ,and memory usage per node………all related to SAP HANA side.
  2. And is there any particular scripts there in sap Hana. To check day to day activities(like: used memory, current running query, related IP users, any error messages……………………………………… ).
  3. And after upgrade sap Hana System, how can we test it is working fine(is there any test plan are there ), on what base I can conform SAP HANA System Working fine  ( if it is working fine after upgrade in test —we have to upgrade in production).

Regards

Ravindar

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Here are some,

1.Per day total user connected to Hana

SELECT * FROM users where LAST_SUCCESSFUL_CONNECT > add_days (now(),-1)

2. how many query are ran per day

SELECT * FROM M_PREPARED_STATEMENTS where LAST_EXECUTED_TIME > add_days (now(),-1)

3. memory usage per node

SELECT * FROM "_SYS_STATISTICS"."HOST_SERVICE_MEMORY" where SERVER_TIMESTAMP > add_days (now(),-1)

4. error code while executing statements

SELECT * FROM M_EXPENSIVE_STATEMENTS WHERE START_TIME > add_days (now(),-1) AND ERROR_CODE <> '0' ORDER BY ERROR_TEXT

reward points if useful.

Meharkiran