Performance Degradation of Single AMP Expedited Queries
While investigating performance degradation for single amp expedited queries I noticed high counts for worktypemax14 in dbc.resusagesawt. All I know is that worktypemax14 (MSGWORKNORMAL) is for "messages that do not fall within the standard work type hierarchy". Some Orange Books describe it as being for "Urgent internal requests". Does anyone know more detail about MSGWORKNORMAL amp worker tasks and what might be triggering their use ? I have looked at dbc.software_event_log without luck.