The developer dashboard is a great new feature that developers can use to aid them in tuning performance on a page. This new functionality adds information to the bottom of any page in SharePoint that displays performance information and what SQL queries were executed to display the page. To my knowledge, there is currently no way in the UI to turn this on, so you can do this with a quick x64 console application. This is soon to become a quite popular code snippet I am sure.
SPPerformanceMonitor performanceMonitor = SPFarm.Local.PerformanceMonitor;
performanceMonitor.DeveloperDashboardLevel = SPPerformanceMonitoringLevel.On;
All you need is those two lines of code. When you are done with it, simply set the monitoring level to Off.