Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Troubleshooting SQL Server Performance with sp_WhoIsActive

via Pluralsight

Overview

sp_WhoIsActive is a free, community-maintained SQL Server stored procedure that helps quickly identify issues with actively-running queries. This course will teach you how to use it to troubleshoot several common scenarios.

Monitoring SQL Server activity is vital to understanding database activity, but most monitoring tools are expensive. In this course, Troubleshooting SQL Server Performance with sp_WhoIsActive, you’ll learn how to effectively monitor SQL Server activity with a free, community-maintained stored procedure. First, you’ll explore the versatile options this tool offers. Next, you’ll discover how to troubleshoot common database performance issues. Finally, you’ll learn how to capture recurring data for analysis or alerts. When you’re finished with this course, you’ll have the skills and knowledge of sp_WhoIsActive needed to effectively identify database performance issues.

Syllabus

  • Course Overview 1min
  • Monitoring SQL Server in Real Time Using sp_WhoIsActive 30mins
  • Capturing and Reporting Activity Using sp_WhoIsActive 11mins

Taught by

Jeff Iannucci

Reviews

4.7 rating at Pluralsight based on 23 ratings

Start your review of Troubleshooting SQL Server Performance with sp_WhoIsActive

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.