seniorT-SQL

What is SQL Server internal query execution context (task, worker, request) relationship?

Updated May 17, 2026

Short answer

A request is a query execution unit, a task represents work to be done, and a worker is the OS thread executing it.

Deep explanation

SQL Server execution is layered. A request is the logical query submitted by a session. Each request is broken into one or more tasks depending on parallelism and operator execution. Workers are SQLOS-managed threads bound to schedulers. Workers execute tasks cooperatively, yielding when waiting for resources. This architecture decouples logical query execution from physical thread execution, enabling fine-grained scheduling, parallelism, and resource governance.

Unlock with a Pro subscription to view this section.

View pricing

Real-world example

No real-world example available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Common mistakes

No common mistakes listed yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

Follow-up questions

No follow-up questions available yet.

Unlock with a Pro subscription to view this section.

Upgrade to Pro

More T-SQL interview questions

View all →