It's been several months since the last Who is Active fix, so I thought I'd call this one out specifically via a blog post. v11.11 contains a few minor fixes and enhancements, which you can read about on the download page. This will (I believe) be the last release that is compatible with SQL Server 2005 and 2008. v11.xx has been quite a stable ...

Fixes the following issues:Bug with transaction information not working for databases with ''th'' in their nameBug with very large CPU times causing an overflow exception on SQL Server 2005Excessive tempdb utilization caused by large string concatenationAdded host_process_id to additional_info collection

Contains fixes for a couple of minor bugs that existed in v11.00.

This post is part 30 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. Pop quiz: What happens when you promise to write 30 posts on a ...

This post is part 29 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. Early in the month I discussed basic security requirements for ...

This post is part 28 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. Over the past month this series has covered a lot of ground. ...

This post is part 27 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. Thanks to your feedback over the past month, I’ve managed to ...

Who is Active? is a comprehensive server activity stored procedure based on the SQL Server 2005 and 2008 dynamic management views (DMVs). Think of it as sp_who2 on a hefty dose of anabolic steroids. Features supported by Who is Active? include: Server activity collection, including data about currently running T-SQL, server resources ...

This post is part 26 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. The CPU is pegged. Your hard disks are fried. Memory ...

This post is part 25 of a 30-part series about the Who is Active stored procedure. A new post will run each day during the month of April, 2011. After April all of these posts will be edited and combined into a single document to become the basis of the Who is Active documentation. Yesterday’s post was about configuring the output based on what ...