sp_BlitzCache shows you the most resource-intensive queries on your SQL Server without running a Profiler trace. Download it free at http://www.BrentOzar.com/blitzcache/
No download links available.
