The Node Knows (A Month of Activity Monitoring, Part 20 of 30)

re: The Node Knows (A Month of Activity Monitoring, Part 20 of 30)

Michael Codanti — Thu, 21 Apr 2011 03:37:54 GMT

Adam,

Thanks for Who Is Active, and the documentation you are writing, I am not only learning more about Who Is Active but SQL Server as well. (Both of which are good things.)

re: The Node Knows (A Month of Activity Monitoring, Part 20 of 30)

spe109 — Thu, 21 Apr 2011 08:24:19 GMT

Hi Adam,

I'd just like to echo what Michael said in a previous post. Thanks for all your hard work both in writing the tool and writing this series of posts.

Thanks

Paul.

re: The Node Knows (A Month of Activity Monitoring, Part 20 of 30)

Adam Machanic — Thu, 21 Apr 2011 14:15:15 GMT

My pleasure :-)

re: The Node Knows (A Month of Activity Monitoring, Part 20 of 30)

Meher — Thu, 21 Apr 2011 21:01:51 GMT

Hi Adam

I am using SQL Server 2005 SP3 and I got the following error message when I ran the following in a original query window:

EXEC sp_WhoIsActive

@get_task_info = 2,

@get_plans = 1

I ran the update statement with a begin tran in the first(original) query window and in a second query window ran the Select Statement with the Row_number clause in it. Then back in the original query window I executed the sp_whoISActive.

Msg 3930, Level 16, State 1, Procedure sp_WhoIsActive, Line 3614

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

Warning: Null value is eliminated by an aggregate or other SET operation.

Msg 3998, Level 16, State 1, Line 1

Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

Is it because I did something wrong?

Thanks

Meher

re: The Node Knows (A Month of Activity Monitoring, Part 20 of 30)

Adam Machanic — Thu, 21 Apr 2011 23:37:47 GMT

Hi Meher,

Your transaction was killed due to an exception -- probably a timeout on getting a query plan. I don't recommend running Who is Active in the middle of a transaction; it's not designed for that.

Best,

Adam

re: The Node Knows (A Month of Activity Monitoring, Part 20 of 30)

Meher — Fri, 22 Apr 2011 02:03:39 GMT

Hi Adam,

Thanks. That explains it why I got the error.

Regards

Meher

Twenty Nine Days of Activity Monitoring (A Month of Activity Monitoring, Part 30 of 30)

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

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