How to find and kill connections to Hana database ?

[former_member230931]

Hi All,

Currently I have run something like below to find connected sessions and kill using studio:

1. find connections a schema

SELECT * FROM"SYS"."M_CONNECTIONS"

WHERE "CURRENT_SCHEMA_NAME" = 'MYSCHEMA'

and "CONNECTION_STATUS" = 'IDLE'

2. kill

ALTER SYSTEM DISCONNECT SESSION'300091

This is too time consuming and by the time I kill one session another one pops up. In the SQL server you have Activity Monitor where you can filter by database and right click to kill a session. Is there something similar in Hana?

I'm an application consultant and I don't have the time to remember commands or write scripts so wondering if there is anything easier in the Hana world.

Thanks

[lbreddemann · Accepted solution]

You can cancel connections in SAP HANA Studio's Admin editor.

Just right-click on the connection you like to cancel.

Concerning "I'm an application consultant and I don't have the time to remember commands..." I'd say you probably shouldn't be administering the database in that case anyhow. If your job doesn't entail this, then you shouldn't be fiddling with it either, as you might cause quite some damage by either not knowing how things work or misunderstanding how they work.

[former_member230931 · Accepted solution]

Thanks Lars...That worked

regarding your comment about not fiddling with the database...agree ....but GUI helps people who are multitasking