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
Overview
Syllabus
Intro
@filter_type and @filter
@get_outer_command
@get_plans
What is REALLY going on now?
What filled up the log?
What filled up tempdb?
What filled up memory?
What is causing the blocking?
Create a table
Create an index
Create a job
Query the table
Taught by
SQLBits
