The Developer Dashboard is one of my favourite troubleshooting tools for SP2010.
The great aspect about the Dev Dashboard is that it allows you to see how long each of your web parts are taking to load on a page, in addition to individual SQL queries and stored proc executions.
Now you can easily figure out which web parts are causing problems so that you can fix them, or hand them off to your developers to fix.