• I think Perfmon is missing in the list; I find it a useful tool for watching, in particular, disk and network IO.

    A packet sniffer of choice can also be very useful; not all issues manifest at the SQL Server level except as "It's slow!".

    A big +1 on Profiler.