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
2 years agoPlexaderm - October 7, 2021
1.32K2 -
5:48
WMAR
2 years agoPlexaderm - October 28, 2021
79 -
1:14
Goanim
2 years ago $0.01 earnedOctober 7, 2021
5334 -
9:07
shaneyyricch
1 day agoAddressing my beef with Harry Sisson
69.5K109 -
1:52:46
Game On!
20 hours ago $2.75 earnedBoston Celtics Can't Win Game 2! | Sports Morning Espresso Shot
58.1K34 -
1:00:01
Trumpet Daily
1 day ago $3.08 earnedMarxist Left Continues to Imprison Trump’s Inner Circle - Trumpet Daily | June 7, 2024
55.9K59 -
11:59:49
The Amber May Show
13 hours ago $12.45 earnedReAwaken America Tour Detroit, MI - DAY 2 | Join General Flynn, Eric Trump, Kash Patel, Mayor Giuliani & Team America + Request Tickets for October 18-19 Selma, NC At: TimeToFreeAmerica.com
85.7K28 -
12:23
Freakin' Reviews
1 day agoRice Robot Review: One-Touch Rice Cooker? | As Seen on TV
86.1K30 -
5:45
Game Developer
1 day agoHow To Become A Game Dev (While Working A Full Time Job)
75.8K15 -
4:16
ryanhoguepassiveincome
1 day ago $12.54 earnedElevate Amazon Ads brand content with your Brand Store
73.6K6