Non-yielding scheduler error in SQL-2014 with SP-3

• N_Muller

  SSCarpal Tunnel

  Points: 4037

  More actions

  July 17, 2019 at 1:18 pm

  #3663750

  Every once in a while we receive a "non-yielding scheduler" error in SQL Server 2014.  We already upgraded to SP-3 which is suppose to resolve this issue.  What exactly this error means? SQL Server doesn't crash immediately, but natively compiled stored procedures start faltering about 1-2 days following this error.  What should be done to address this issue short of restarting/failing-over SQL Server?  Is there anything that should be done in the stored procedures?

  Thanks in advance.

• DinoRS

  SSCrazy

  Points: 2683

  More actions

  July 17, 2019 at 2:40 pm

  #3663788

  Have you tried applying SP3-CU2 at least? If that doesn't help open a support ticket with Microsoft. This error is related to spin-locks most likely.