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 » Wait States » Performance   (RSS)
  • Wait Statistics in Microsoft SQL Server

     (Originally appearing at http://kevinekline.com/2013/10/09/wait-statistics-in-sql-server/).When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics.  In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular ...
    Posted to Kevin Kline (Weblog) by KKline on October 9, 2013
  • 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