Skip to Content
0

How to check memory trend or CPU utilization trend in HANA?

Jun 22, 2017 at 04:20 AM

91

avatar image
Former Member

I want to check memory trend or CPU utilization trend in HANA. Is there any script to check the same.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Frank Schuler
Jun 22, 2017 at 05:23 AM
0

Hello Parag,

Out-of-the box, SAP HANA Studio already provides you with current and peak memory and CPU usage:

Best regards

Frank


peak.png (54.1 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Frank,

If we click on Dashboard monitoring in HANA studio & click on CPU usage, it shows current data only.

I want to check memory trend for a particular period.
Some queries are going to be run tomorrow & we need to collect the CPU/memory stats during that time. What is the best way to do this?Is there any script to check the same.

Thanks in advance,

Parag Jhade

0
Former Member

Hello Frank,

How can we find out which users have kept idle sessions? Can we write a script to kill idle sessions?

Also, can we find out which queries are consuming huge resources?

0