The SQL Server SOS_SCHEDULER_YIELD is a fairly common wait type and it could indicate one of two things: SQL Server CPU scheduler is utilized properly and is working efficiently or There is a pressure on CPU. Read more at the SQL Shack from Nikola Dimitrijevic..
Wow, Paul Randal has put together probably the most comprehensive library of all wait types and latch classes that have existed since SQL Server 2005. This will be extremely important to all the Performance Tuners out there to really understand what is slowing your SQL code down. I can’t believe…