A few days ago someone posted a link to this very nice tool on LinkedIn:
a .NET application that provides realtime performance data on the target SQL Server instance.
No installation required, data displayed in realtime, and can also be logged to CSV for offline analysis. Will also capture SQL data for processing uing PAL.
It needs quite a bit of permissions to run, guess also registry access??
The tool itself in action: