THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline


You might encounter a situation, under a very heavy workload, where processing for certain transactions starts out very efficiently, but over time becomes much less efficient. 


A good place to start troubleshooting is, of course, PerfMon.  But PerfMon can fail to reveal the culprit, since the CPU can remain stable and moderate while still experiencing this problem.  It’s time to pull out a more granular troubleshooting tool, the SQL Server 2005 DMV wait states.  Of course, you won’t encounter this exact problem every time, but sometimes you might find that you have ever increasing SOS_SCHEDULER_YIELD waits occurring.  BOL provides this illuminating description of the wait:


"Occurs when a task voluntarily yields the scheduler for other tasks to execute. During this wait the task is waiting for its quantum to be renewed."


Now, I can count the number of times after a hard day’s work that I want to get my quantum renewed.  You?  Anyway, the description doesn’t explain much. 


That’s why you need to learn more about %signal waits in this blog post:


Thanks to the SQL CAT team for figuring out this problem and thanks to Bill Graziano and Linchi Shea for pointing out the issue.

Published Wednesday, May 14, 2008 12:06 PM by KKline

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS,

This Blog



Privacy Statement