Unlocking the Power of WhoIsActive by Jeff Iannucci

Title: Unlocking the Power of WhoIsActive
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.


Speaker: Jeff Iannucci
Senior Consultant at Straight Path Solutions

Jeff Iannucci is a Senior Consultant with Straight Path Solutions. With over 20 years of experience with SQL Server development and administration, he enjoys sharing what he's learned by speaking, blogging, and creating video content. He is a speaker at PASS Data Community Summit 2022, a content author for Pluralsight, and author of the upcoming book "Learn SQL in a Month of Lunches".