A Gift of Script for 2009: Who is Active, Redux

A year in review, The 31 best blog posts on SQLBlog for 2008

Denis Gobo — Wed, 31 Dec 2008 15:37:49 GMT

Wow, it has been already a year since I wrote A year in review, The 21 + 1 best blog posts on SQLBlog

re: A Gift of Script for 2009: Who is Active, Redux

Moham Mawla — Sat, 03 Jan 2009 09:00:09 GMT

Great job Adam , happy new year for you

re: A Gift of Script for 2009: Who is Active, Redux

Adam Machanic — Sun, 04 Jan 2009 15:06:40 GMT

Happy New Year to you too, Mohammed! I hope all is well in Egypt.

re: A Gift of Script for 2009: Who is Active, Redux

Bill — Sun, 25 Jan 2009 21:09:23 GMT

Msg 8114, Level 16, State 1, Line 1

Error converting data type bigint to int.

I ran your script as is and i got above error..

re: A Gift of Script for 2009: Who is Active, Redux

Adam Machanic — Mon, 26 Jan 2009 17:34:06 GMT

Hi Bill,

Hard to say what's causing that, but it has to be one of a couple of places that use dynamic SQL. I just checked and it looks like I did get a couple of datatypes wrong, but it's unlikely you would hit them (I hope) -- the main ones are reads/writes. If you select from sys.dm_exec_sessions do you see any sessions with more than two billion reads or writes? That seems like a lot to me, but I know some systems keep sessions connected for a long, long time, so I guess it could build up...

Also, did you use any parameters?

I'm working on a fix for the datatypes I know I got wrong, and also am adding some new functionality; I hope to have a new version out in a day or two. Thanks for the feedback!

re: A Gift of Script for 2009: Who is Active, Redux

Bill — Wed, 28 Jan 2009 08:18:09 GMT

Thx Adam

No, I ran exec_sessions and nothing with more than 2 billion reads or writes.

I ran it without specifying any parameters. Thx Bill

re: A Gift of Script for 2009: Who is Active, Redux

Adam Machanic — Wed, 28 Jan 2009 15:59:38 GMT

Bill,

Can you drop me a line at amachanic [at] gmail [dot] com ? I would like to send you a modified version and see if it fixes things.

re: A Gift of Script for 2009: Who is Active, Redux

aspiringgeek — Thu, 05 Feb 2009 02:56:15 GMT

Adam, I want to let you know I used an older version along with my SQL Deltoids with great success at a recent engagement. I'll look forward to trying the new! improved! version at my next opportunity. Among other clever features, the XML column in the result set is wonderful.

Who is Active? v7.30

Adam Machanic — Wed, 18 Feb 2009 16:01:05 GMT

Who is Active? is a comprehensive DMV-based monitoring script, designed to tell you at a glance what