Who is Active? v7.30http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/02/18/who-is-active-v7-30.aspxWho is Active? is a comprehensive DMV-based monitoring script, designed to tell you at a glance what processes are active on your SQL Server and what they're up to. It has a number of optional features so that you can get results quickly, or monitor deeply,enCommunityServer 2.1 SP2 (Build: 61129.1)re: Who is Active? v7.30http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/02/18/who-is-active-v7-30.aspx#12808Fri, 20 Mar 2009 16:36:16 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12808lance<p>cool script. i'm no dba so i don't know how to use half of the data, but i did notice it wouldn't work on our server because it's case sensitive. had to change cpu to uppercase and SYSNAME to lowercase to get it to work.</p>
re: Who is Active? v7.30http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/02/18/who-is-active-v7-30.aspx#12816Fri, 20 Mar 2009 17:24:17 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12816Adam Machanic<p>Hi Lance,</p>
<p>Thanks for the feedback regarding case sensitivity. &nbsp;That's something I'm currently working on fixing in new versions of the script.</p>
re: Who is Active? v7.30http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/02/18/who-is-active-v7-30.aspx#12904Wed, 25 Mar 2009 17:26:34 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12904CG<p>What version of SQL does this tool work on..</p>
<p>It's not mentioned anywhere that I can see!!</p>
re: Who is Active? v7.30http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/02/18/who-is-active-v7-30.aspx#12911Wed, 25 Mar 2009 20:41:07 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:12911Adam Machanic<p>Hi CG,</p>
<p>SQL Server 2005 SP1+ (I use the memory grants DMV, which was added with SP1 as I recall), and SQL Server 2008. &nbsp;I'll add that to the notes; thanks for the feedback.</p>
Who is Active? v8.40 - Now With Delta Power!http://www2.sqlblog.com/blogs/adam_machanic/archive/2009/02/18/who-is-active-v7-30.aspx#13007Mon, 30 Mar 2009 16:53:35 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:13007Adam Machanic<p>It has been only a month and a half since I posted the last version of Who is Active? ( v7.30 ), but</p>