3228858 - High usage of memory by Pool/Statistics because of JDBC client

• You are using system which connects to SAP HANA database using SAP HANA JDBC client e.g.
  
  • SAP Solution Manager
  • SAP Manufacturing Execution System (MES)
  • etc.
• You experience high memory usage in allocator (SQL Statement: "HANA_Memory_Overview") e.g.
  
  • Pool/RowEngine/QueryExecution/SearchAlloc
  • Pool/Statistics
• You experience very high number e.g. 100.000 or even 1.000.000 "M1152 Max. SQL contexts per connection" and it increases over time (SQL Statement: "HANA_Configuration_MiniChecks")
  The following example shows 3 days of increased contexts per connection:
  

  CHID	DESCRIPTION	VALUE	EXPECTED_VALUE	C	SAP_NOTE
  M1152	Max. SQL contexts per connection	226035	<= 5000	X	2000002
  M1152	Max. SQL contexts per connection	418163	<= 5000	X	2000002
  M1152	Max. SQL contexts per connection	627449	<= 5000	X	2000002

• You have also all the other symptom which are listed in SAP Note 2711824
• You can experience SAP HANA Alert 43 - Memory usage of services
• Used memory never be released by itself. To solve the issue and release the memory you need to restart the database or you need to cancel the connections manually.

SAP HANA, platform edition 2.0

OOM, out of memory, M1152, Pool/Statistics, Pool/RowEngine/QueryExecution/SearchAlloc, high memory, transactionalLobs=false, connection string, JDBC, client , KBA , HAN-DB-ENG , SAP HANA DB Engines , Bug Filed