We invite you to join us for our February 2020 meeting on Wednesday the 15th at Epicentral Coworking featuring a presentation by Glenn Alan Berry on Dr. DMV's Troubleshooting Toolkit.
When: 5:30 PM to 8:00 PM
Where: Epicentral Coworking, 415 N Tejon, Colorado Springs, CO
What: We'll begin with networking and dinner from 5:30 to 6:00 PM. At 6:00, we'll have a few announcements and peer Q&A time followed by our presentations. After the presentations and some SWAG, we'll have time for socializing and additional networking. The CSSUG will provide drinks while you network.
Dr. DMV's Troubleshooting Toolkit by the prestigious Glenn Alan Berry!
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.
Glenn works as a Consultant in Elizabeth, CO. He was a Data Platform MVP from[masked]. 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 the author of the book SQL Server Hardware. Glenn blogs regularly at https://glennsqlperformance.com/. He is active on Twitter as @GlennAlanBerry.
Note that beginning January 2020, parking meters are in effect until 10PM. There is limited free parking behind Epicentral.