Product has been added to your cart.

1.3 Lab 1 Solution: Watch Brent Work Through It (51m)

Brent starts the Lab 1 workload, then steps through a quick SQL Server health check with sp_Blitz, then captures wait stats details with sp_BlitzFirst @ExpertMode = 1, @Seconds = 60. From there, he runs sp_BlitzIndex to check the server’s index designs, and sp_BlitzCache to check which queries were causing the top wait types. He finishes…

You’ll need a membership to access this course. Check out my training classes.

Brent starts the Lab 1 workload, then steps through a quick SQL Server health check with sp_Blitz, then captures wait stats details with sp_BlitzFirst @ExpertMode = 1, @Seconds = 60. From there, he runs sp_BlitzIndex to check the server’s index designs, and sp_BlitzCache to check which queries were causing the top wait types. He finishes…

You'll need a membership to access this course. Check out my training classes.