Who is Active? v7.30

re: Who is Active? v7.30

lance — Fri, 20 Mar 2009 16:36:16 GMT

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.

re: Who is Active? v7.30

Adam Machanic — Fri, 20 Mar 2009 17:24:17 GMT

Hi Lance,

Thanks for the feedback regarding case sensitivity. That's something I'm currently working on fixing in new versions of the script.

re: Who is Active? v7.30

CG — Wed, 25 Mar 2009 17:26:34 GMT

What version of SQL does this tool work on..

It's not mentioned anywhere that I can see!!

re: Who is Active? v7.30

Adam Machanic — Wed, 25 Mar 2009 20:41:07 GMT

Hi CG,

SQL Server 2005 SP1+ (I use the memory grants DMV, which was added with SP1 as I recall), and SQL Server 2008. I'll add that to the notes; thanks for the feedback.

Who is Active? v8.40 - Now With Delta Power!

Adam Machanic — Mon, 30 Mar 2009 16:53:35 GMT

It has been only a month and a half since I posted the last version of Who is Active? ( v7.30 ), but