posted 12/1/2009 by MikeMollenhour - Views: [1056]
I recently had an issue that I wanted to verify that my partitioning strategy was working and distributing the workload as I hoped. Windows 2008 has a great feature to do this built into Task Manager. First open Task Manager by right clicking toolbar and selecting start task manager (nothing new there). Then just click resource monitor and open DISK by double clicking and then sort by write by double clicking the header for write b/min. This proves to be a very useful way to see if your tempdb is being loaded as well.