THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Internals » troubleshooting » Wait States   (RSS)
  • SOS_SCHEDULER_YIELD

    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 ...
    Posted to Kevin Kline (Weblog) by KKline on May 14, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement