3153253 - Job Monitoring application access is very slow - SAP ASE for Business Suite

• On Solution Manager  systems running on the SAP ASE database, access to the "Job Monitoring" application for certain Technical Systems is very slow.
• The underlying slow sql query is:

SELECT "CLIENT" ,"CONTEXT_ID" ,"TYPE_ID" ,"HASH_METRIC_PATH" ,"START_TIMESTAMP" ,"END_TIMESTAMP" ,"METRIC_PATH" ,"RATING_AGGREGATE" ,"VALUE_MIN" ,"VALUE_MAX" ,"VALUE_SUM" ,"VALUE_COUNT" ,"VALUE_LAST" ,"VALUE_DATA_TYPE" ,"VALUE_MAX_TIME" ,"LAST_TEXT" ,"EXPIRE_TIMESTAMP_MIN" ,"EXPIRE_TIMESTAMP_MAX" FROM "MES_DB_AGGREGATE" WHERE "CLIENT" = ? AND ( ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) OR ( "CONTEXT_ID" = ? AND "TYPE_ID" = ? AND "IS_CURRENT" = ? ) ) /* R3:CL_MES_NODE_AGGREGATE_MGR=====CP:972 T:MES_DB_AGGREGATE M:100 */

• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite 
• SAP Solution Manager 7.2

KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem