SAP HANA database performance issue | Generic Symptoms

Please visit our blog to get more knowledge.
rupeshschavan.blogspot.com
The purpose of this video is to help you to find the probable root cause of some generic problems.
** Component memory allocation ****
SELECT host, component, sum(used_memory_size) used_mem_size FROM PUBLIC.M_SERVICE_COMPONENT_MEMORY
group by host,component ORDER BY sum(used_memory_size) desc;
** Active statements **
Select "LAST_EXECUTED_TIME","APPLICATION_SOURCE", "CONNECTION_ID","STATEMENT_ID","STATEMENT_STATUS","STATEMENT_STRING", "USED_MEMORY_SIZE", "LAST_ACTION_TIME" from "SYS"."M_ACTIVE_STATEMENTS"

[@spiritual_battle.]

Thank you sir

[@tonyng1730]

Nicely done. Thank you.

[@sapadministrationlearningp3747]

Thanks for watching!

[@veerangre6682]

nicely explained.

[@maheahayela]

Nice explanation

[@Balubalraj]

Helpful video plz do more videos

[@sapadministrationlearningp3747]

Thank you, I will

[@TheOptimisticMagician]

Thanks sir. For amazing explanation

[@sapadministrationlearningp3747]

Most welcome

[@koteswararao786]

How to analyze a particular trace file like index server trace do we need to read all the 30000 lines or any technique there

[@sanjeevkataria7444]

Very nicely explained Buddy!

[@sapadministrationlearningp3747]

Glad you liked it

[@oguzsahin2571]

hi,
Priority:
4 (High)
Alert ID:
105
Alert Name:
Total Open Transactions Check
Description:
93% out of 64000 reached for service hostname:31011
The check monitors the number of open transactions per service
User Action:
Double check if the application is closing the connection correctly, and whether the high transaction load on the system is expected.
How fix it? Do you know?

[@koteswararao786]

One particular table is using high memory consuming how to analyze

[@SnSActivityHub]

Need some real time or scenerio based videos

[@RohitThakur-yp3tf]

Nicely explained

[@sapadministrationlearningp3747]

Thanks for liking

[@user-fv1op2ji4n]

Hi , can you share Hana books.

[@chakradhar7444]

Good Video

[@sapadministrationlearningp3747]

Thanks for the visit

[@user-yu4yd2qr2w]

Excellent

[@sapadministrationlearningp3747]

Thanks

[@adilsgr]

Nice

[@sapadministrationlearningp3747]

Thanks

[@dileepreddy61]

good info bro

[@sapadministrationlearningp3747]

Glad you liked it

[@koteswararao786]

Hana db is slow how to troubleshoot

[@sapadministrationlearningp3747]

apologies for the late response and thanks for your comment. I will try to cover your topic soon.