Dr. DMV with Jupyter Notebooks

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.