There's a particularly fine article on Enterprise Performance Tools inside the December 2004 issue of MSDN Magazine.

Update - the full text of the article is now available online at the following link:

http://msdn.microsoft.com/msdnmag/issues/04/12/EnterprisePerformance/

(including some screenshots)