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.

The other useful feature is that you can toggle the dashboard, so that it doesn’t load on each and every page, just the ones you want it to  – by clicking a button.

To enable the dashboard in toggle mode, simply run this command:

stsadm -o setproperty -pn developer-dashboard -pv OnDemand