1910159 - How to handle HANA Alert 25: ‘Check number of connections’

When checking the Alerts tab in HANA Studio or Solution Manager there is an alert called “Number of connections is 242, Number of maximum connections is 150”For HANA Studio you would find the alert by going to Administration Console -> Alerts -> Show: all alerts -> Filter input ‘connections’.

• 
   
• For Solution Manager, you would find the alert using transaction DBACOCKPIT -> choose HANA system -> expand Current Status -> Alerts
  Remember for this “Check number of connections” alert in Solution Manager, it is auto-refreshed every 15 minutes, so the time stamp on the alert may be not the exact time when the alert occurs.
  To check the exact time please go to Administration Console -> Alerts -> double click on the alerts -> more occurrences for this alert.
   
  

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental

SAP HANA Database

Operations REcommendation; #OpsRec-HANA; maximum_connections ; idle_connection_timeout; HOST_LONG_IDLE_CURSOR; IDLE_TIME; DISCONNECT SESSION; , KBA , HAN-DB-MON , SAP HANA Monitoring , Problem