DAT421: Peeking Inside SQL Serverhttp://blogs.msdn.com/sqlserver/archive/2006/06/14/630732.aspxI've attached the scripts used in this Teched session...enCommunityServer 2.1 SP1 (Build: 61025.2)Interesting Finds: June 14, 2006 AM editionhttp://blogs.msdn.com/sqlserver/archive/2006/06/14/630732.aspx#630933Wed, 14 Jun 2006 17:52:47 GMT91d46819-8472-40ad-a661-2c78acb4018c:630933Jason Haleyre: DAT421: Peeking Inside SQL Serverhttp://blogs.msdn.com/sqlserver/archive/2006/06/14/630732.aspx#8969636Tue, 30 Sep 2008 03:07:22 GMT91d46819-8472-40ad-a661-2c78acb4018c:8969636Felipe Ferreira<p>really nice the script to see the top 10 consuming queries... thanks for sharing with the community Jason</p> <p>regards</p>