Symptom
- 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 */
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Solution Manager 7.2
Product
Keywords
KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.