How to Determine Activity on Each Processor in SQL Server

The contents of the SELECT, WHERE and ORDER BY clauses are all a matter of determining the story you need to tell.
by Tim Ford via IT Pro - Microsoft Windows Information, Solutions, Tools