Next Meeting: Tue, Jun 30 2015
June User Group Meeting
Event Type: In-Person
Online Meeting URL: None
UTC : Tue, Jun 30 2015 21:00 - 23:00
Event Time : Tue, Jun 30 2015 17:00 - 19:00 Eastern Daylight Time
Your Local Time: Tue, Jun 30 2015 21:00 - 23:00
2000 Technology Dr
Dr. DMV's Troubleshooting Toolkit
Glenn Berry, Principal Consultant SQLskills
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 numerous DMV queries that you can quickly and easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.
Glenn Berry works as a principal consultant at SQLskills in Parker, CO. He is a SQL Server MVP and has a 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, and storage subsystems. Glenn is also an adjunct faculty member at University College - University of Denver, where he has taught since 2000.