I, as some of the other posts here have suggested, would go for repeated calls to the DMV over a long period of time (a few weeks at the least...

Hi Steve

A great suggestion and good use for log-shipping. As an ex-DBA I was often called upon to fix an "oops" and one does need to fix a way of...

Hi Wes,

Certainly on Idera's SQLSafe backup and restore product we switched to async IO a while back now.

We also added (and patented) using a PID Controller (http://en.wikipedia.org/wiki/PID_controller)...

Great article!

Just some personal observations:

1. On larger queries SQL Server read-ahead kicks in and it reads 512KB blocks at a time. In my observations disks are much better at long...