I had a chance to play with one of the Hosted experience offerings talked about yesterday and chose to go with the SQL 2005 tuning offering
http://msdn.microsoft.com/vstudio/tryit/hosted/sql/sqlquerytuning/
The profiler has a number of changes, the most obvious being the deadlock diagram
Of course, this information could be gathered in previous versions of SQL (using trace flags etc) but this makes it a whole lot simpler.
Another new piece of functionality was the ability to save execution plans in graphical format - prior to this I had to rely on screendumps.