Albuquerque SQL Server User Group

What's Happening?

Next Meeting: Fri, Nov 13 2015

November Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None

November meeting


UTC : Fri, Nov 13 2015 18:30 - 20:30
Event Time : Fri, Nov 13 2015 11:30 - 13:30 (UTC-07:00) Mountain Time (US & Canada)
Your Local Time: Fri, Nov 13 2015 18:30 - 20:30


5100 Masthead St NE
Albuquerque, New Mexico

Direction: None

Featured Presentation

Dr. DMV's Troubleshooting Toolkit

Speaker: Glenn Berry, Principal Consultant SQLskills

Summary: Dynamic management views (DMVs) 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, identify the 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 about how to interpret the results of each diagnostic query, including relevant background information about how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases to avoid many performance and scalability issues.

About Glenn: 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. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dive and SQL Server MVP Deep Dives Volume 2 books. Glenn blogs regularly at He is active on Twitter as @GlennAlanBerry.


Please be sure to check out our page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at





Back to Top