$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content

How to find and kill connections to Hana database ?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 27, 2017 at 02:50 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded