Browse by Tags

(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 ...

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 ...