2026-04-09

Major Versioning and Non-Behavioral Script Changes

• Removed the legacy who_is_active.sql file
• Broke script into different versions based on targeted SQL Server compatibility (see README.MD in the root folder)
• Changed versioning scheme to include compatibility information and release date (see README.MD in the root folder)
• Normalize line endings and strip trailing whitespace

Behavioral Changes and Enhancements

• Treat 'dormant' sessions the same as 'sleeping'
• Add XACT resource type to lock object name resolution
• Use CAST with DECIMAL(38, 0) for query_cost to prevent arithmetic overflow
• Add encrypt_option to additional_info XML

New Features

• Resolve SQL Agent job names in program_name column
• Add LOB compression via @format_output bitmask

Fixes

• Add SET STATISTICS XML OFF to prevent capturing own execution plan
• Fix CPU column ordering on case-sensitive collation instances
• Escape XML processing instruction delimiters in sql_text, sql_command, and query_plan
• Fix block_leaders error on Azure SQL DB by conditionally including broker DMV
• Remove sys.dm_os_threads CPU delta feature in newer versions
• Fix nvarchar conversion errors in lock parsing by using TRY_CAST

Thanks

Huge thanks to Erik Darling for producing the majority of the above work!

v12.00

• New parameter, @get_memory_info, that exposes memory grant information, both in two top-level scalar columns and a new XML-based memory_info column.
• Better handling of the newer CX* parallelism wait types that have been added post-2016
• A top-level implicit_transaction identifier, available in @get_transaction_info = 1 mode
• Added context_info and original_login_name to additional_info collection
• A number of small bug fixes
• Transition code to use spaces rather than tabs

New file name: Not an enhancement per se, but please note that starting with this release there is a new source file, sp_WhoIsActive.sql. The old file, who_is_active.sql, will be kept around for a few months and then removed. Please migrate any processes that might be using the old name.

v11.35

Couple of minor fixes.

Initial GitHub Release

v11.33

Re-added accidentally deleted copyright notice