windows server 2003 monitoring software combining SQL Server monitoring with CPU-IO stats
You're unhappy with the built in functionality profiler provides where you can combine perfmon data files?
The magic happens in Profiler with the File->Import Performance Data... option. What this means is you can click on your perform graph (where your CPU is spiking) and profiler will jump to the corresponding capture that was happening at that moment.
This was a new feature introduced in SQL Server 2005.
check this out