User Group Aug 9th Meeting - Lunch

Topic: Dr. DMV's Troubleshooting Toolkit - Live online 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 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.

Speaker: Glenn Berry, Principal Consultant of SQLSkills.com

Bio: Glenn is a Microsoft SQL Server MVP. He has worked as a SQL Server professional for many years in a variety of roles, including stints with NewsGator and Avalara. 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. Glenn is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, SQLintersection, 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.

Food

: Food is being provided by Tek Systems.

Reminder to all: Please register as a member of PASS ( http://sqlpass.org | it's FREE), and associate yourself with our chapter. It's how they keep track of our activity, and our size, which will help us when the SQLSaturday thing comes around. (Spring 2017!)

Home Page: http://eugene.sqlpass.org/

Contact us via email at: eugene.oregon@sqlpass.org
We have a discussion board at http://groups.google.com/group/eugenesql?hl=en.

Ask your questions and hear from the community.

Also, like us on Facebook here: https://www.facebook.com/groups/123723384306270/requests/?notif_t=group_r2j Follow us on Twitter: @EugeneSQL

or our LinkedIn Group: https://www.linkedin.com/groups/3681739