5:30 - Networking with Pizza.
6:00 - Meeting begins
6:15 - Glenn's presentation
7:45 - Paul's reflections on easy ways to use Glenn's code
1st (Main) Presentation
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 is a Principal Consultant with SQLskills. He has worked as a SQL Server professional for many years in a variety of roles, most recently as Database Architect for Avalara in Parker, CO. Glenn has been a SQL Server MVP since 2007, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves he likes to take tests. His expertise includes DMVs, high availability, hardware selection and configuration, and performance tuning. 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 University College. Glenn 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 Dives and SQL Server MVP Deep Dives Volume 2 books. Glenn’s personal blog is at http://sqlserverperformance.wordpress.com, his SQLskills blog is at http://www.SQLskills.com/blogs/glenn, and he can be reached by email at [masked], and on Twitter as GlennAlanBerry.
2nd (shorter) Presentation
Paul will demonstrate some ways to leverage on Glenn's code.
Paul Paiva has been working with SQL since 1995 and still likes it.