The Output of Your Dreams (A Month of Activity Monitoring, Part 24 of 30)

Capturing the Output (A Month of Activity Monitoring, Part 25 of 30)

Adam Machanic — Wed, 27 Apr 2011 04:42:21 GMT

This post is part 25 of a 30-part series about the Who is Active stored procedure. A new post will run

Adam Machanic — Sat, 30 Apr 2011 15:45:21 GMT

This post is part 30 of a 30-part series about the Who is Active stored procedure. A new post will run

Jeremy Marx (@jmarx) — Fri, 03 Jun 2011 16:33:32 GMT

Adam,

On 11.00, if I use @format_output = {0|2}, the [dd hh:mm:ss.mss] and [dd hh:mm:ss.mss (avg)] columns won't show.

Ex:

EXEC master..[sp_WhoIsActive] @format_output = 0 -- columns don't show up

EXEC master..[sp_WhoIsActive] @format_output = 1 -- columns show up

EXEC master..[sp_WhoIsActive] @format_output = 2 -- columns don't show up

Noticed on 9.0.5000 and also tested on 10.50.1600.

Adam Machanic — Fri, 03 Jun 2011 18:06:16 GMT

Hi Jeremy,

Thanks for the report. It's not supposed to show up for @format_output = 0, but it should for @format_output = 2.

--Adam