Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Archive for November 18th, 2016

SOS_SCHEDULER_YIELD due to SpinLock issue.

Posted by Simon Cho on 11/18/2016

First of all we can check SQL server version since there is patch regarding bucket count.



And here is really good blog about this issue.

Spinlocks, When To Worry About Them and Solutions To Common Problems


Posted in Common | Tagged: , | Leave a Comment »