New WP published a little while back that talks about troubleshooting SQL Server 2005 using some of the new technologies to help. Its written by the customer advisory team, Customer Support Team and members of SQL Server Database engine team, in other words the folks that really know.