That begs the questions. Are there any effective *online* disk defragmentation programs that actually work for SQL Server database volumes? Perhaps a newer version of Diskeeper?

Randolph,

How did you obtain the wait states by percentage breakdown in this post?

Grant,

Thanks for the response. I do have the instance where it executed. I might have the developers search their codebase.

I'll try looking for the proverbial needle-in-a-haystack in the cache.

Jeffrey,

On x64 hardware, Microsoft says that the "Lock pages in memory" right is not necessary. From this Technet article:

http://technet.microsoft.com/en-us/library/ms190730.aspx

"Locking pages in memory is not required on 64-bit...

Thanks, that answered my question!