Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Posts Tagged ‘SpinLock’

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 »