17883

Product

Name

Event ID

17883

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

SRV_SCHEDULER_NONYIELDING

Message

Text

Process %ld:%ld:%ld (0x%lx) Worker 0x%p appears to be non-yielding on Scheduler %ld.

Thread creation time: %I64d. Approx Thread CPU Used: kernel %I64d ms, user %I64d ms.

Process Utilization %d%%. System Idle %d%%. Interval: %I64d ms.

Indicates that there’s a possible problem with a thread not yielding on a scheduler. This error

may be caused by an operating system condition, environment issue, or software issue in SQL

Server, or if SQL Server isn’t getting enough cycles to execute. This error may go away if the

thread eventually yields.

If you look at the error message information, you see that certain behaviors emerge. For

example:

If user mode time quickly climbs and continues to do so, the likely cause is an unbounded

loop in the SQL Server engine that isn’t properly yielding.

ﾉ

Expand table