We may earn an affiliate commission when you visit our partners.
Jeff Iannucci
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.
Read more
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.
Read more
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.
This course is no longer available. Find something similar by browsing:
SQL Server
sp_WhoIsActive
Database Performance
Query Optimization
Performance Monitoring
Register for this course and see more details by visiting:
OpenCourser.com/course/wdw9pu/troubleshooting
What's inside
Syllabus
Traffic lights
Traffic lights
Read about what's good
what should give you pause and
possible dealbreakers
Teaches how to use sp_WhoIsActive, which is an essential tool for monitoring SQL Server
Taught by Jeff Iannucci who is widely recognized and respected in the field of database performance tuning
Examines real-time monitoring of SQL Server performance, which is invaluable for optimizing database performance
Develops skills and knowledge in troubleshooting common database performance issues, which are core skills for database administrators
Builds strong foundation in using sp_WhoIsActive for performance monitoring and troubleshooting
Save this course
Create your own learning path.
Save this course to your list so you can find it easily later.
Save
Save
Reviews summary
Practical sql server performance troubleshooting
According to students, this course on sp_WhoIsActive is an excellent and highly practical resource for anyone managing SQL Server performance. Learners consistently highlight its clear and concise explanations and effective demonstrations, which make the complex topic easy to grasp. Many found the content immediately useful, enabling them to apply the techniques directly to their daily work and troubleshoot database performance issues with ease. The course is particularly praised for being to the point and packed with valuable, actionable knowledge, making it a must-have for database administrators looking to efficiently monitor and optimize SQL Server.
Uses strong examples and demos to illustrate concepts.
"I really appreciated the practical demonstrations that helped me quickly get started."
"The course provides good examples which are very useful."
"The great demonstrations were very useful and helped me understand the concepts immediately."
Highly recommended for database administrators and professionals.
"Great course with useful information and good examples. I would highly recommend it for any DBA."
"It's absolutely essential for anyone managing SQL Server, due to its excellent content and clear explanations."
"This course is very helpful for my daily work and provides valuable practical knowledge."
The instructor delivers content with exceptional clarity.
"The explanations are clear, and the content is to the point and extremely helpful."
"Absolutely brilliant, with excellent explanations and clear examples, essential for managing SQL Server."
"I found the instructor's teaching style clear and easy to understand, providing practical knowledge."
"The course is very well done, clear and concise, making it immediately applicable."
Provides practical knowledge that can be used right away.
"This course is excellent and useful. I was able to quickly get started with sp_WhoIsActive to monitor SQL Server."
"Very good course. The content is clear and concise, with great demonstrations that are immediately useful."
"I found this course incredibly practical and helpful; it's very useful in daily work."
"I learned practical tools and strategies that I could apply immediately to my work."
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Troubleshooting SQL Server Performance with sp_WhoIsActive with these
activities:
Review SQL Basics
Show steps
Ensure that your foundational knowledge of SQL is strong to better grasp the concepts covered in this course.
Show steps
-
Revisit SQL syntax and commands.
-
Practice writing basic SQL queries.
Analyze Query Performance with sp_WhoIsActive
Show steps
Gain hands-on experience analyzing query performance using sp_WhoIsActive, enhancing your troubleshooting skills.
Show steps
-
Set up a test environment with SQL Server.
-
Run sp_WhoIsActive on a sample database.
-
Interpret the results and identify performance bottlenecks.
Show all two activities
Review SQL Basics
Show steps
Ensure that your foundational knowledge of SQL is strong to better grasp the concepts covered in this course.
Show steps
Show steps
Show steps
- Revisit SQL syntax and commands.
- Practice writing basic SQL queries.
Analyze Query Performance with sp_WhoIsActive
Show steps
Gain hands-on experience analyzing query performance using sp_WhoIsActive, enhancing your troubleshooting skills.
Show steps
Show steps
Show steps
- Set up a test environment with SQL Server.
- Run sp_WhoIsActive on a sample database.
- Interpret the results and identify performance bottlenecks.
Show all two activities
Career center
Learners who complete Troubleshooting SQL Server Performance with sp_WhoIsActive will develop knowledge and skills
that may be useful to these careers:
Database Developer
Database Developer
Database Developers can take advantage of sp_WhoIsActive to monitor and improve database performance, which is vital to ensuring their applications perform efficiently. Strengthening their skills and knowledge with sp_WhoIsActive will make a Database Developer more valuable to their organization.
Database Administrator
Database Administrator
Database Administrators ensure no interruption or downtime for their organizations. They are experts on solving performance issues, which makes knowing about sp_WhoIsActive a vital asset to troubleshooting. You will also learn how to monitor real-time SQL Server activity which is crucial to the daily responsibilities of a Database Administrator for managing and maintaining databases.
SQL Developer
SQL Developer
This course would be helpful for an SQL Developer as it will build a foundation in using sp_WhoIsActive. This free, community-maintained stored procedure can help identify performance issues in actively-running queries.
Data Analyst
Data Analyst
A Data Analyst uses their knowledge to identify trends and patterns. The ability to troubleshoot performance issues using sp_WhoIsActive can help strengthen the overall infrastructure that data is collected and maintained, making a Data Analyst that much more successful.
Software Engineer
Software Engineer
For Software Engineers, this course can help build a foundation in monitoring SQL Server performance. You will learn how to effectively use the free, community-maintained stored procedure called sp_WhoIsActive. This knowledge on stored procedures will be valuable for career advancement.
Systems Analyst
Systems Analyst
For Systems Analysts, this course may be useful as it will build a foundation in monitoring SQL Server performance. You will learn how to effectively use the free, community-maintained stored procedure called sp_WhoIsActive.
IT Manager
IT Manager
As an IT Manager, this course may be useful as it will provide insight into database monitoring. You will learn how to effectively use the free, community-maintained stored procedure called sp_WhoIsActive to diagnose performance issues.
Data Scientist
Data Scientist
This course may be useful for Data Scientists as it can build a foundation in SQL Server performance tuning. You will learn valuable insights into optimizing database performance with sp_WhoIsActive, thereby expanding your capabilities as a Data Scientist.
Data Engineer
Data Engineer
For a Data Engineer, this course may be useful in building a foundation in SQL Server performance tuning. You will learn valuable insights into optimizing database performance with sp_WhoIsActive, which can complement your skills in data engineering.
Business Analyst
Business Analyst
This course may be useful for a Business Analyst as it can be beneficial to have knowledge of SQL Server performance tuning. You will gain insights into optimizing database performance with sp_WhoIsActive, which can be valuable for understanding the technical aspects of data analysis.
Information Security Analyst
Information Security Analyst
This course may be useful for an Information Security Analyst as it will provide insights into SQL Server performance tuning. You will gain knowledge of optimizing database performance with sp_WhoIsActive, which can contribute to the security and efficiency of databases.
Software Architect
Software Architect
This course may be useful for Software Architects as it covers the fundamentals of SQL Server performance tuning. You will gain valuable knowledge on optimizing database performance with sp_WhoIsActive, which can be beneficial for designing and implementing robust software solutions.
Project Manager
Project Manager
For a Project Manager, this course will provide insights into SQL Server performance tuning. You will gain knowledge of optimizing database performance with sp_WhoIsActive, which can be beneficial for managing projects that involve data-driven applications.
Technical Writer
Technical Writer
This course may be useful for a Technical Writer as it provides a foundation in SQL Server performance tuning. You will gain valuable knowledge on optimizing database performance with sp_WhoIsActive, which can enhance your ability to document and explain technical concepts related to database management.
Quality Assurance Analyst
Quality Assurance Analyst
For a Quality Assurance Analyst, this course will provide knowledge of SQL Server performance tuning. You will gain insights into optimizing database performance with sp_WhoIsActive, which can enhance your ability to test and ensure the quality of software applications that utilize SQL Server.
For more career information including salaries, visit:
OpenCourser.com/course/wdw9pu/troubleshooting
Reading list
We've selected 13 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Troubleshooting SQL Server Performance with sp_WhoIsActive.
Save
Provides advanced techniques for indexing and query tuning in SQL Server. It valuable resource for experienced SQL Server professionals who want to improve the performance of their databases.
Provides practical guidance on how to improve the performance of SQL Server databases. It covers a wide range of topics, including indexing, query optimization, and hardware tuning.
Practical guide to SQL Server query performance tuning. It covers a wide range of techniques for improving query performance, including indexing, query optimization, and hardware tuning.
Provides a clear and concise explanation of SQL performance concepts. It valuable resource for anyone who wants to understand the underlying principles of SQL performance and how to improve it.
Provides a detailed overview of SQL Server execution plans. It explains how the optimizer works and how to interpret execution plans to improve performance.
Provides a practical guide to SQL Server 2012 performance tuning. It is written by a leading expert in the field and is packed with useful tips and tricks.
Provides a comprehensive guide to SQL Server execution plans. It is an essential resource for anyone who wants to understand how SQL Server optimizes and executes queries.
Provides a detailed overview of the internal workings of SQL Server. It explains how SQL Server processes queries, manages data, and handles concurrency. This book would be a useful reference for students who want to gain a deeper understanding of the underlying architecture of SQL Server.
Provides a comprehensive guide to SQL Server query performance tuning. It is written by a leading expert in the field and is packed with useful tips and tricks.
Provides a practical guide to SQL Server high performance tuning. It is written by a leading expert in the field and is packed with useful tips and tricks.
Provides a comprehensive guide to SQL Server database administration. It covers a wide range of topics, from basic administration tasks to advanced techniques for managing and maintaining SQL Server databases.
Save
Provides a comprehensive guide to SQL Server query tuning. It is written by a leading expert in the field and is packed with useful tips and tricks.
Provides a comprehensive guide to SQL Server performance monitoring. It covers a wide range of topics, from basic monitoring techniques to advanced techniques for troubleshooting performance issues.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/wdw9pu/troubleshooting
Share
Similar courses
Similar courses are unavailable at this time. Please try again later.
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2025 OpenCourser