SQL Server Performance: Root Cause Analysis with DMVs

Using Dynamic Management Views and Functions to gather and analyze performance data from SQL Server.

   Watch Promo   Enroll in Course

Troubleshooting performance issues in SQL Server is an essential skill to any database administrator or engineer. Gathering the data necessary to understand a problem can be a taxing part of the process. In my experience with SQL Server, DMVs have become my first source for quick data on what is happening in a SQL Server instance.

In this course, I will walk you through a number views and functions that can provided the detailed information you need to understand performance issues in SQL Server. I will provide a example scripts for each view and function showing how I've used these in the past, and there will be discussion of how to interpret the data we access. I'll also share some stories from my own experience where one of these scripts was especially effective. Overall, this course has over two hours of lecture, discussion, and examples.

All of this is intended to help you quickly identify the root cause of performance issues in SQL Server. Becoming adept at troubleshooting SQL Server performance issues has had a huge impact on my career, and I hope this information will be as beneficial to you as it was to me.

Your Instructor

Jared Poche
Jared Poche

Jared Poché is a a database engineer and administrator with 15 years of industry experience with SQL Server, and a 10 year veteran of Microsoft CSS. Jared has spoken at multiple SQL Saturday events, has experience as both a tech lead and a instructor for certification classes, and is currently optimizing database performance for a multinational e-commerce company.

Frequently Asked Questions

When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

I very much hope that you have enjoyed my first online course. This has been a great experience for me, since I am an avid learner myself and love to teach eager students.

In this course, we have reviewed a number of views and functions that provide a wealth of information about SQL Server's performance. I hope you are able to put this information and the examples I've provided to good use and make advances in your career and understanding of SQL Server.

Please stay tuned as I intend to create additional courses going forward. Feedback is always appreciated, and let me know if you would like to take a class on another topic related to SQL Server.

Get started now!