READ80TRACE and OSTRESS are two useful --but unsupported-- tools used by the Microsoft SQL Server Product Support teams. They can be downloaded from here (1.7M .exe).