Explore advanced SQL Server monitoring techniques using WhoIsActive in this 20-minute conference talk by Jeff Iannucci at SQLBits. Learn about powerful features such as @filter_type, @filter, @get_outer_command, and @get_plans to gain deeper insights into database activity. Discover how to identify processes filling up logs, tempdb, and memory, as well as pinpoint blocking causes. Gain practical knowledge on creating tables, indexes, and jobs to enhance your monitoring capabilities. Suitable for database administrators and SQL professionals seeking to improve their server performance analysis skills.
Unlocking the Power of WhoIsActive - Monitoring SQL Server Activity