One of my pals, MVP Liam Cleary, posted a very interesting article on how to use Visual Studio 2008 to test the performance of your SharePoint Solution.

I urge you to check his article out : http://www.helloitsliam.com/archive/2008/03/10/moss2007-testing-using-visual-studio-team-system-2008.aspx