October 2021 - Dr. DMV's Troubleshooting Toolkit by Glenn Berry (@GlennAlanBerry)
Abstract
Dynamic Management views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates, and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.
This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases in order to avoid performance and scalability issues.
Prerequisites: Some experience with SQL Server 2005 and later
About Speaker
Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit.
-
5:47
WMAR
3 years agoPlexaderm - October 7, 2021
2.43K2 -
5:48
WMAR
2 years agoPlexaderm - October 28, 2021
84 -
1:14
Goanim
3 years ago $0.01 earnedOctober 7, 2021
5614 -
1:29:54
Donald Trump Jr.
14 hours agoMcMaga: We’re Lovin’ it, Plus “Bulletproof” Author Jack Posobiec | TRIGGERED Ep.183
122K372 -
2:29:19
WeAreChange
10 hours agoLegacy Media DESTROYS ITSELF While Trying To Take Out Trump!
70K33 -
53:46
Kimberly Guilfoyle
14 hours agoDonald Trump’s Most Iconic Moment Yet? Live with Dinesh D’Souza & David Bossie | Ep. 167
76.9K41 -
1:01:18
Sarah Westall
10 hours agoAre you being Duped? Woke Right vs Woke Left, Infiltration & Operations w/ James Lindsay
41.3K10 -
1:43:58
2 MIKES LIVE
10 hours ago2 MIKES LIVE #132 Deep Dive Monday with Special Guest BIANCA DE LA GARZA!
24.7K2 -
1:01:44
Exploring With Nug
14 hours ago $1.99 earnedPolice Refuse To Let Others HELP Investigate Missing Person Randy Leach!
18.7K2 -
1:28:40
Redacted News
12 hours agoEMERGENCY! AMERICAN BOMBERS ON NUCLEAR ALERT AS ISRAEL PREPARES MASSIVE ATTACK ON IRAN | REDACTED
165K395