- Course
Troubleshooting SQL Server Performance with sp_WhoIsActive
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.
Intermediate
- Course
Troubleshooting SQL Server Performance with sp_WhoIsActive
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.
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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.
Troubleshooting SQL Server Performance with sp_WhoIsActive
Intermediate
Table of contents
Jeff Iannucci has been solving data problems for over 20 years, primarily using Microsoft’s SQL Server. With experience in both database development and administration, he has resolved issues in diverse environments such as health care, finance, retail sales, and government. He specializes in performance tuning and query optimization, and he is passionate about helping professional colleagues grow their database knowledge and skills.