
Be worried sick; be sick with worry
Emotional Intensity
The phrase implies a deep emotional distress that can affect one's physical health. 
Colloquial Usage
It's a common informal expression, not suitable for formal writing, but widely understood in conversation. 
Not Literal
Being 'sick with worry' doesn't always mean being physically ill, but describes feeling emotionally overwhelmed. 