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
2008 R2 CU3 10.50.1734.0

non-yielding scheduler error; complex view with large number of nested views or tables
2008 R2 CU5 10.50.1753.0

Non-yielding Scheduler error; CONTAINSTABLE with many OR/AND predicates
2008 R2 CU5 10.50.1753.0

Non-yielding Scheduler error after Microsoft SQL Server Native Client 10.0 application connection
2008 R2 CU6 10.50.1765.0

Non-yielding scheduler error; Table valued parameter + SQL Profiler or SQL Server Extended Events
2008 R2 CU7 10.50.1777.0

Non-yielding Resource Monitor
2008 R2 SP1 10.50.2500.0

Non-yielding Scheduler error; CHARINDEX function
2008 R2 SP1 CU5 10.50.2806.0

Non-yielding Scheduler; profiling session (to calculate cost of object cache) not closed correctly
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
2008 R2 SP1 CU7 10.50.2817.0

No comments:

Post a Comment