OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course Discontinued We've found some alternatives for you:

Top Active Alternatives

SQL Server 2017: Diagnosing Performance Issues with DMVs is no longer accepting new enrollments. We've matched the highest-rated active courses in this subject:

Read Reviews → Enroll Active
Read Reviews → Enroll Active
Read Reviews → Enroll Active
Pluralsight logo

SQL Server 2017

Diagnosing Performance Issues with DMVs

Glenn Berry

Learn how to easily query SQL Server 2017 for performance information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for SQL Server 2017 and earlier versions.

Read more

Learn how to easily query SQL Server 2017 for performance information to help identify and fix issues that can affect performance and stability. This course is applicable to anyone responsible for SQL Server 2017 and earlier versions.

It is very common for SQL Server instances to have workload performance problems in one or more ways. In this course, SQL Server 2017: Diagnosing Performance Issues with DMVs, you will see more than 45 DMV queries you can use to easily examine performance information related to your workload, instance health, and storage health. First, you will learn how to detect and correct many common performance issues related to the overall activity on the SQL Server instance and around the storage subsystem. Next, you will be shown how to investigate memory and CPU issues at the instance level. Finally, you will see how to drill into the database level and investigate performance issues there. By the end of this course, you will be able to find and correct the most common SQL Server performance issues. This course is perfect for anyone who is responsible for a SQL Server 2017 instance, with most topics also applicable to SQL Server 2016 and earlier versions.

This course is no longer available. Find something similar by browsing:
SQL Server Performance Tuning Database Management Dynamic Management Views (DMVs) Instance Health Storage Health Memory Management

What's inside

Syllabus

Course Overview
Introduction
Diagnosing Activity-related Instance Issues
Diagnosing Storage-related Instance Issues
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Examines SQL Server 2017 performance, which is highly relevant to database administrators
Explores common SQL Server 2017 performance issues, which is standard in the industry
Teaches use of DMVs, which helps learners monitor and improve SQL Server performance
Covers various aspects of SQL Server performance, including activity, storage, memory, and CPU issues, which provides a comprehensive understanding
Appropriate for individuals responsible for SQL Server 2017 and earlier versions

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Practical dmv diagnostics for sql server performance

Learners say this course is a highly practical and valuable resource for anyone involved in SQL Server performance diagnostics. It's particularly praised for its clear explanations of complex DMVs and immediate applicability of queries to real-world scenarios. Many found the instructor's delivery engaging and knowledgeable, making the content easy to follow. While excellent for those seeking a strong foundation or a comprehensive refresher, some intermediate to advanced users felt certain topics could benefit from more advanced techniques or additional interactive labs beyond the helpful demonstrations. Overall, it's considered an essential tool for identifying and resolving common SQL Server performance issues.
Content is current for SQL Server 2017, with minor suggestions for newer versions.
"My only suggestion would be to update it for newer SQL Server versions as well, though 2017 is still widely used."
"This course is applicable to anyone responsible for SQL Server 2017 and earlier versions."
Provides useful demonstrations, but some desire more interactive labs.
"The demos are hands-on and incredibly helpful."
"While the content on DMVs is theoretically sound, I felt the course lacked sufficient hands-on exercises or challenges beyond just following the instructor's demos."
"I learn best by doing, and simply watching wasn't enough to solidify the concepts for me. Could use more interactive labs."
Excellent for foundational learning; some advanced users desired more depth.
"A very solid course for anyone looking to get started with diagnosing SQL Server performance using DMVs."
"As an intermediate DBA, I was hoping for more advanced diagnostic methods. It covers the basics well, but didn't push me much further."
"For experienced professionals, it might serve as a refresher or fill in some gaps."
"Good for beginners though."
Instructor delivers content clearly, breaking down complex topics effectively.
"The instructor breaks down complex DMVs into understandable concepts with clear, practical examples."
"The content is well-structured, and the instructor explains things thoroughly."
"The instructor's delivery is engaging and easy to follow. This course truly delivered on its promise."
"The detailed explanations of each DMV and how to interpret their output were invaluable."
Highly practical with immediately applicable DMV queries for real-world issues.
"This course is absolutely fantastic! ...I still learned new tricks and gained a deeper understanding of performance bottlenecks. The demos are hands-on and incredibly helpful."
"I particularly appreciated the focus on practical DMV queries that I can immediately apply in my daily work."
"Incredibly practical and directly applicable. I loved how the instructor went straight to the point, showing relevant DMV queries without unnecessary fluff."
"I now feel much more confident in identifying and resolving issues."

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 SQL Server 2017: Diagnosing Performance Issues with DMVs with these activities:
Find a More Experienced SQL Server Developer as a Mentor
Connect with an experienced SQL Server developer who can provide guidance and support as you learn and grow
Browse courses on Mentoring
Show steps
  • Attend industry events and meetups
  • Reach out to people in your professional network
  • Search online forums and communities
Mentor Junior SQL Server Developers
Share your knowledge and experience by mentoring junior SQL Server developers to reinforce your own learning and deepen your understanding
Browse courses on Mentoring
Show steps
  • Find a junior developer who is eager to learn
  • Set up regular meetings to discuss SQL Server concepts
  • Provide guidance and support on specific projects
Review SQL Basics
Brush up on SQL basics to refresh your memory and prepare for more advanced topics
Show steps
  • Review SQL syntax and data types
  • Practice writing basic SELECT, INSERT, UPDATE, and DELETE statements
Nine other activities
Expand to see all activities and additional details
Show all 12 activities
Review Advanced SQL Concepts
It will ensure that you have a solid understanding of the fundamental SQL concepts before diving into performance-related topics.
Show steps
  • Review your notes or study materials on advanced SQL concepts such as indexing, query optimization, and stored procedures.
  • Practice writing efficient SQL queries using advanced techniques.
Review Modern Database Management
Review Modern Database Management core concepts - database design, data modeling, storage structure and query processing - to reinforce your learning
Show steps
  • Read chapters 1-3 and take notes on key concepts
  • Complete the exercises at the end of each chapter
  • Create a simple database design for a small business
Explore SQL Server DMV Tutorials
They will provide practical examples and hands-on experience in using DMVs for performance troubleshooting.
Browse courses on Dynamic Management Views (DMVs)
Show steps
  • Find online tutorials or documentation on SQL Server DMVs.
  • Follow the tutorials to learn how to use specific DMVs for performance analysis.
Query SQL Server Using T-SQL
Practice writing T-SQL queries to improve your understanding of data retrieval and manipulation
Browse courses on SQL Server
Show steps
  • Review T-SQL basics (SELECT, FROM, WHERE)
  • Write queries to retrieve data from different tables
  • Use joins to combine data from multiple tables
  • Practice writing queries to update and delete data
Analyze Queries with Query Store
It will enable you to practice analyzing query execution plans and identifying performance bottlenecks.
Browse courses on Query Store
Show steps
  • Enable Query Store on your SQL Server instance.
  • Run a workload or execute queries to generate data in Query Store.
  • Use Query Store views to analyze query execution plans and identify performance issues.
Configure and Optimize SQL Server Indexes
Learn how to create and manage indexes to improve the performance of your SQL Server databases
Browse courses on SQL Server
Show steps
  • Understand the different types of indexes
  • Create and modify indexes using SQL Server Management Studio
  • Monitor and troubleshoot index performance
  • Optimize indexes for specific queries
Contribute to SQL Server Open Source Projects
Contribute to open source SQL Server projects to gain hands-on experience and expand your knowledge beyond the classroom
Browse courses on Open Source
Show steps
  • Find a project that aligns with your interests
  • Read the project documentation and contribute to discussions
  • Submit a bug report or feature request
  • Make code contributions to the project
Document Performance Recommendations
It will allow you to synthesize your findings and provide practical recommendations for improving performance.
Show steps
  • Analyze the performance data and identify areas for improvement.
  • Develop specific recommendations for optimizing queries, tuning indexes, or adjusting server settings.
  • Create a detailed document outlining your recommendations.
Design a Database for a Real-World Application
Create a database design for a real-world application to apply your knowledge of database concepts and SQL Server
Browse courses on Database Design
Show steps
  • Identify the requirements of the application
  • Create an entity-relationship diagram
  • Normalize the data model
  • Create the database tables and columns
  • Test the database design

Career center

Learners who complete SQL Server 2017: Diagnosing Performance Issues with DMVs will develop knowledge and skills that may be useful to these careers:
Database Manager
Database Managers oversee database systems. They are tasked with planning, creating, and administering these systems in order to meet the needs of their organization. They may also be responsible for developing and implementing security measures, disaster recovery plans, and performance optimization strategies. This course may be useful for aspiring Database Managers as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of a database system.
See salaries and explore the career path for Database Manager
Cloud Architect
Cloud Architects design, plan, and manage cloud computing systems. They work with clients to determine their needs, then design and implement solutions that meet those needs. They may also be responsible for managing the security and performance of cloud systems. This course can be helpful for aspiring Cloud Architects as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of a cloud computing system.
See salaries and explore the career path for Cloud Architect
Database Administrator
Database Administrators manage and maintain database systems. They are responsible for ensuring the security, performance, and availability of databases. This course can be helpful for aspiring Database Administrators as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of a database system.
See salaries and explore the career path for Database Administrator
Systems Administrator
Systems Administrators manage and maintain computer systems. They are responsible for ensuring the security, performance, and availability of systems. This course can be helpful for aspiring Systems Administrators as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of computer systems.
See salaries and explore the career path for Systems Administrator
Network Administrator
Network Administrators manage and maintain computer networks. They are responsible for ensuring the security, performance, and availability of networks. This course can be helpful for aspiring Network Administrators as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of computer networks.
See salaries and explore the career path for Network Administrator
Cloud Engineer
Cloud Engineers design, deploy, and manage cloud computing systems. They may work with clients to determine their needs, then design and implement solutions that meet those needs. They may also be responsible for managing the security and performance of cloud systems. This course can be helpful for aspiring Cloud Engineers as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of a cloud computing system.
See salaries and explore the career path for Cloud Engineer
DevOps Engineer
DevOps Engineers work to bridge the gap between development and operations teams. They are responsible for ensuring that software is developed and deployed in a way that meets the needs of both teams. This course can be helpful for aspiring DevOps Engineers as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of software development and deployment.
See salaries and explore the career path for DevOps Engineer
IT Consultant
IT Consultants provide guidance to businesses on how to use technology to meet their business needs. They may work with businesses to develop IT strategies, select and implement software and hardware, and manage IT systems. This course may be helpful for aspiring IT Consultants as it can help them learn how to diagnose and correct performance issues, which can be a valuable skill for helping clients to optimize their IT systems.
See salaries and explore the career path for IT Consultant
Machine Learning Engineer
Machine Learning Engineers design, develop, and deploy machine learning models. They work with data from a variety of sources to create models that can be used to solve a variety of problems. This course may be helpful for aspiring Machine Learning Engineers as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective development and deployment of machine learning models.
See salaries and explore the career path for Machine Learning Engineer
Business Intelligence Analyst
Business Intelligence Analysts use data to help businesses make informed decisions. They may work with data from a variety of sources to create reports, visualizations, and dashboards that can be used to track performance, identify trends, and make predictions. This course may be helpful for aspiring Business Intelligence Analysts as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of data and the creation of business intelligence reports.
See salaries and explore the career path for Business Intelligence Analyst
Data Analyst
Data Analysts collect, clean, and analyze data to help businesses make informed decisions. They may use data mining, statistical analysis, and machine learning to identify trends and patterns in data. This course may be helpful for aspiring Data Analysts as it can help them learn how to diagnose and correct performance issues, which is a critical skill for managing and analyzing data.
See salaries and explore the career path for Data Analyst
Software Engineer
Software Engineers design, develop, and maintain software applications. They may work on a variety of projects, from small personal apps to large enterprise systems. This course may be useful for aspiring Software Engineers as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the development and maintenance of software applications.
See salaries and explore the career path for Software Engineer
Web Developer
Web Developers design, develop, and maintain websites and web applications. They may work on a variety of projects, from small personal websites to large e-commerce sites. This course may be helpful for aspiring Web Developers as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the development and maintenance of websites and web applications.
See salaries and explore the career path for Web Developer
Data Engineer
Data Engineers design, build, and maintain data pipelines. They work with data from a variety of sources to create data products that can be used by businesses to make informed decisions. This course may be helpful for aspiring Data Engineers as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of data pipelines.
See salaries and explore the career path for Data Engineer
Data Scientist
Data Scientists use data to solve a variety of problems. They may work with data from a variety of sources to create models that can be used to predict outcomes, identify trends, and make recommendations. This course may be helpful for aspiring Data Scientists as it can help them learn how to diagnose and correct performance issues, which is a critical skill for the effective management of data and the development of data science models.
See salaries and explore the career path for Data Scientist

Reading list

We've selected eight 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 SQL Server 2017: Diagnosing Performance Issues with DMVs.
Cover image
SQL Server Advanced Troubleshooting and Performance...
Save
Offers valuable guidance on troubleshooting common SQL Server performance issues, including issues related to specific queries, database structure, and hardware.
SQL Server Advanced Troubleshooting and Performance...
Kindle Edition
$$
Cover image
Microsoft SQL Server 2012 High-Performance T-SQL...
Save
Covers a wide range of performance tuning topics, including query optimization, index design, and hardware optimization, making it a valuable resource for understanding the principles and techniques of performance tuning.
Microsoft SQL Server 2012 High-Performance T-SQL...
Paperback
$$$
Microsoft SQL Server 2012 High-Performance T-SQL...
Kindle Edition
$$
Microsoft SQL Server 2012 High-Performance T-SQL...
Paperback
$$$$
Cover image
T-SQL Querying
Save
Focuses specifically on diagnosing and resolving query performance issues in SQL Server, providing practical guidance and real-world examples.
T-SQL Querying (Developer Reference)
Paperback
$$$
T-SQL Querying (Developer Reference)
Kindle Edition
$$
Cover image
SQL Server Advanced Troubleshooting and Performance...
Save
Emphasizes the identification and resolution of performance issues related to SQL queries, providing a structured approach to query optimization and troubleshooting.
SQL Server Advanced Troubleshooting and Performance...
Paperback
Check
SQL Server Advanced Troubleshooting and Performance...
Kindle Edition
Check
Cover image
Query Store for SQL Server 2019
Save
Dives deep into the topic of SQL Server execution plans, providing detailed insights into how queries are optimized and executed, which is crucial for performance analysis and optimization.
Query Store for SQL Server 2019: Identify and Fix...
Paperback
$$
Query Store for SQL Server 2019: Identify and Fix...
Kindle Edition
$$
Cover image
Pro SQL Server 2012 Practices
Save
Targets SQL Server 2016 specifically, providing detailed guidance on performance tuning techniques, troubleshooting, and best practices.
Pro SQL Server 2012 Practices (Expert's Voice in...
Paperback
$$
Cover image
Microsoft SQL Server 2012 Unleashed
Save
Introduces the use of PowerShell for performance monitoring and troubleshooting in SQL Server, providing practical guidance on automating performance analysis tasks.
Microsoft SQL Server 2012 Unleashed
Kindle Edition
$$$
Cover image
Microsoft SQL Server 2019: A Beginner's Guide,...
Save
While intended as an introductory guide to SQL Server, this book provides a solid foundation for understanding the basics of SQL Server, which can be beneficial for learners who are new to the platform.
Microsoft SQL Server 2019: A Beginner's Guide,...
Paperback
$$
Microsoft SQL Server 2019: A Beginner's Guide,...
Kindle Edition
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to SQL Server 2017: Diagnosing Performance Issues with DMVs.
Mastering Advanced SQL Queries
Most relevant
Microsoft SQL Server: Performance Tuning Essentials
Most relevant
The Ultimate SQL Bootcamp: Zero to Hero in 9 Hours
Most relevant
Workload Manager Validation for SQL Server
Most relevant
SQL Server Administration Part 2
Most relevant
SQL Server Performance Tuning: Testing & Dev Practical...
Most relevant
Top Database Bundle: MySQL, PostgreSQL, SQLite3, SQL...
Most relevant
Advanced SQL Server Performance Tuning
Most relevant
SQL Server 2017: Diagnosing Configuration Issues with DMVs
Most relevant

Pluralsight Buyer Protection & Guarantee

Verified partner policies & purchase protections

Enterprise Technology Platform
Free Trial & Audit

10-Day Free Trial

10-day free trial (up to 200 minutes of content) with access to the Skills video library and skill assessments. Cancel before day 10 to avoid automatic conversion.

Return & Refund Policy

Cancel Anytime (Non-Refundable Once Billed)

Cancel easily online anytime before the 10-day trial expires to prevent billing. Once subscription fees are paid, individual subscriptions are non-refundable (cancellation stops future renewals).

Buyer Protections

Verified Academic & Industry Partner

Skill IQ and Role IQ diagnostic benchmark assessments, hands-on lab environments, and curated learning paths designed by technology leaders.

Key Purchase Protections
10-day free trial on individual Skills plans
Skill IQ assessments to benchmark proficiency
Cancel anytime online before trial ends without fees
Hands-on interactive labs and enterprise-grade tech content
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Time
164 hours
Level
Intermediate
Via
Pluralsight
Instructor
Glenn Berry
Language
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Examines SQL Server 2017 performance, which is highly relevant to database administrators
Explores common SQL Server 2017 performance issues, which is standard in the industry
Teaches use of DMVs, which helps learners monitor and improve SQL Server performance
Covers various aspects of SQL Server performance, including activity, storage, memory, and CPU issues, which provides a comprehensive understanding
Appropriate for individuals responsible for SQL Server 2017 and earlier versions
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
This course is currently discontinued or unavailable. See active alternatives above.
Course Unavailable
Save for later
Add this course to your list. Find it anytime.
Save
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