In his December 2006 MSDN Magazine article, Jonathan Keljo from the CLR team at Microsoft takes a high-level look at the types of tools that can be written using the CLR Profiling API.  It's a great overview: http://msdn.microsoft.com/msdnmag/issues/06/12/CLRInsideOut/default.aspx.