on 05-02-2013 10:22 PM
Hi Experts,
I am working on SAP HANA Administrator.
I Have some issues.
Regards
Ravindar
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.