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

Introduction to Data Science in Python
University of Michigan via Coursera
Julia Scientific Programming
University of Cape Town via Coursera
Python for Data Science
University of California, San Diego via edX
Probability and Statistics in Data Science using Python
University of California, San Diego via edX
Introduction to Python: Fundamentals
Microsoft via edX