SQL Server A to Z – Waits

In the world of SQL Server, a process is either running, runnable, or waiting. A running process is, obviously, running; it’s the one getting CPU time. A runnable process has everything it needs to run, it’s just waiting for its turn on the CPU. A process that’s waiting, however, is one that needs some resource [...]

November 28, 2011  Tags: ,   Posted in: Troubleshooting  No Comments

This will make a great blog post someday…

Ever have one of those days when you feel like you know absolutely nothing?В  That pretty much sums up the past week for me.В  I’ve been fighting with a performance problem and have come up empty on all fronts. WTF? We’re in the middle of a project to upgrade one of our financial databases.В  The [...]

August 29, 2011  Tags: , ,   Posted in: Troubleshooting  5 Comments