Harness Stress for Focus and Productivity

Stress is generally associated with negative mental and physical consequences. But can it actually be a healthy, even sought-after phenomenon at times?