Microsoft – SQLServer – Error – Non-Yielding Scheduler – External dump process return code 0x20000001

Microsoft – SQLServer – Error – Non-Yielding Scheduler – External dump process return code 0x20000001

The full error message is something like:

2012-10-05 10:14:35.24 Server Using 'dbghelp.dll' version '4.0.5'
2012-10-05 10:14:35.24 Server ***Unable to get thread context for spid 0
2012-10-05 10:14:35.24 Server * *******************************************************************************
2012-10-05 10:14:35.24 Server *
2012-10-05 10:14:35.24 Server * BEGIN STACK DUMP:
2012-10-05 10:14:35.24 Server * 10/05/12 10:14:35 spid 6708
2012-10-05 10:14:35.24 Server *
2012-10-05 10:14:35.24 Server * Non-yielding Scheduler
2012-10-05 10:14:35.24 Server *
2012-10-05 10:14:35.24 Server * *******************************************************************************
2012-10-05 10:14:35.24 Server Stack Signature for the dump is 0x0000000000000100
2012-10-05 10:14:35.69 Server External dump process return code 0x20000001.
External dump process returned no errors.

2012-10-05 10:14:35.69 Server Process 0:0:0 (0x19d8) Worker 0x0000000009C6A1A0 appears to be non-yielding on Scheduler 22.
Thread creation time: 12993930288147. Approx Thread CPU Used: kernel 0 ms, user 71167 ms.
Process Utilization 4%. System Idle 95%. Interval: 71183 ms.
2012-10-05 10:14:56.10 Logon Error: 18456, Severity: 14, State: 11.

The error return code (0x20000001) could presumably mean various things.  Per our current Blog it conveys what MS refers to as:

This issue occurs because the profiling session is not closed correctly. The profiling session is used to calculate the cost of an object to be cached, and is based on memory usage and CPU usage.

To remediate apply the latest Service Pack / Cumulative update.

References:

  1. FIX: SQL Server 2012, SQL Server 2008 R2 or SQL Server 2008 stops responding and a “Non-yielding Scheduler” error is logged
    http://support.microsoft.com/kb/2699013

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s