Wednesday, October 30, 2013

SQL Server 2008 R2 fixes for non-yielding scheduler and such

 This ain't gonna be entertaining, and for most not very enlightening, either.  I just came across this list in my stuff and didn't want to lose it again :).

Non-yielding scheduler error or error 8623; query with large IN clause
http://support.microsoft.com/kb/982376
2008 R2 CU3 10.50.1734.0

non-yielding scheduler error; complex view with large number of nested views or tables
http://support.microsoft.com/kb/2306162
2008 R2 CU5 10.50.1753.0

Non-yielding Scheduler error; CONTAINSTABLE with many OR/AND predicates
http://support.microsoft.com/kb/2344600
2008 R2 CU5 10.50.1753.0

Non-yielding Scheduler error after Microsoft SQL Server Native Client 10.0 application connection
http://support.microsoft.com/kb/2491214
2008 R2 CU6 10.50.1765.0

Non-yielding scheduler error; Table valued parameter + SQL Profiler or SQL Server Extended Events
http://support.microsoft.com/kb/2520808
2008 R2 CU7 10.50.1777.0

Non-yielding Resource Monitor
http://support.microsoft.com/kb/2216485
2008 R2 SP1 10.50.2500.0

Non-yielding Scheduler error; CHARINDEX function
http://support.microsoft.com/kb/2633357
2008 R2 SP1 CU5 10.50.2806.0

Non-yielding Scheduler; profiling session (to calculate cost of object cache) not closed correctly
http://support.microsoft.com/kb/2699013
2008 R2 CU 14 10.50.1817.0, SP1 CU7 10.50.2817.0

Non-yielding IO Completion Listener or IOCP Listener; Winsock behavior when 2398202 and 2491214 are installed
http://support.microsoft.com/kb/2711549
2008 R2 SP1 CU7 10.50.2817.0

No comments:

Post a Comment