Unlocking the Power of WhoIsActive

Jeff Iannucci

For years many SQL Server professionals have been using the free, community-maintained stored procedure WhoIsActive to troubleshoot problematic activity. Unfortunately, most of us only use the default results instead of using this wonderful tool to its fullest capabilities.

In this session, you’ll learn about helpful non-default options in the latest version of WhoIsActive, how to utilize them to quickly identify resource contention or blocking, and how to capture recurring data for later analysis. You’ll leave with a better understanding of how to use WhoIsActive more effectively to resolve troublesome activity on your SQL Server instances.