3334173 - High runtime of license measurement in SYSTEMDB

• Monitoring of the SYSTEMDB reveals that the SQL statement for license auditing consumes a significant amount of CPU resources:
  

  HASH: 8559ff443a3816983aeac38377e37d8d

  INSERT INTO SYS.LICENSE_MEASUREMENTS_ SELECT GLAS_APPLICATION_ID, MEASURE_TIME, VALUE, 1 SUCCESSFUL, HOST, PORT, DATABASE_NAME, APPLICATION_INSTANCE_ID 
  FROM SYS.M_LICENSE_MEASUREMENT_STATISTICS_ LMS_ 
  WHERE    
  LMS_.DATABASE_NAME NOT IN (SELECT DISTINCT DATABASE_NAME FROM SYS.LICENSE_MEASUREMENTS_)    
  OR (LMS_.DATABASE_NAME <> 'SYSTEMDB'        
  AND LMS_.MEASURE_TIME > (SELECT MAX(MEASURE_TIME)                               
  FROM SYS.LICENSE_MEASUREMENTS_ LM_                              
  WHERE LMS_.DATABASE_NAME = LM_.DATABASE_NAME))

• The number of tenants in the HANA instance is quite high (>=10).

SAP HANA, platform edition 2.0

KBA , HAN-DB , SAP HANA Database , Problem