YoVDO

Dr. DMV with Jupyter Notebooks

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Jupyter Notebooks Courses Performance Tuning Courses Storage Optimization Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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 DBAs
MongoDB 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