Dr. DMV with Jupyter Notebooks
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
Explore an in-depth session on utilizing Dynamic Management Views (DMVs) and functions to diagnose and optimize SQL Server performance using Jupyter Notebooks. Dive into a comprehensive set of diagnostic DMV queries that enable easy detection and resolution of configuration and performance issues in SQL Server instances and databases. Learn to identify top wait types, CPU-intensive stored procedures, missing indexes, and unused indexes. Gain valuable insights on interpreting query results, along with essential background information on properly configuring hardware, storage subsystems, operating systems, SQL Server instances, and databases to prevent performance and scalability problems. Originally presented at PASS Summit 2020, this extensive 2-hour 17-minute talk provides a wealth of practical knowledge for SQL Server professionals seeking to enhance their diagnostic and optimization skills.
Syllabus
Dr. DMV with Jupyter Notebooks - Glenn Berry
Taught by
PASS Data Community Summit
Related Courses
MongoDB for DBAsMongoDB University Optimizing Performance for SQL Based Applications
Microsoft via edX App Deployment, Debugging, and Performance
Google Cloud via Coursera Application Deployment, Debug, Performance 日本語版
Google Cloud via Coursera Optimize TensorFlow Models For Deployment with TensorRT
Coursera Project Network via Coursera