What's Happening?

Next Meeting: Fri, Nov 13 2015

November Meeting

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

November meeting

When

iCal
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

Where

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 Berry works as a principal consultant at SQLskills in Elizabeth, CO. He is a Data Platform 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.

Attachments

Please be sure to check out our Meetup.com 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 http://www.sqlpass.org/.