Dr. DMV's Troubleshooting Toolkit

Offered By: PASS Data Community Summit via YouTube

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Explore a comprehensive set of diagnostic DMV queries for detecting and diagnosing configuration and performance issues in SQL Server instances and databases. Learn how to interpret query results and gain insights into properly configuring hardware, storage subsystems, operating systems, SQL Server instances, and databases to avoid performance and scalability problems. Discover techniques to identify top wait types, CPU-intensive stored procedures, missing indexes, and unused indexes. Delve into exhaustive details on result interpretation and acquire essential background information for optimal SQL Server performance tuning in this 2.5-hour conference talk from PASS Data Community Summit.

Syllabus

Dr. DMV's Troubleshooting Toolkit - Glenn Berry

Taught by

PASS Data Community Summit

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube Transform Your Data Estate
PASS Data Community Summit via YouTube Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube