Next Meeting: Thu, Jan 15 2015
EDMPASS Jan-2015 Meeting with Glenn Berry
Event Type: In-Person & Online
Online Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=MN6B24&role=attend&pw=X%5E2Bxh2wg
5:30 pm - Food and socializing
5:45 pm - Group announcement - Brent Flesher
6:00 pm - Feature Presentation - Glenn Berry
8:00 pm - Networking
UTC : Fri, Jan 16 2015 00:30 - 04:00
Event Time : Thu, Jan 15 2015 17:30 - 21:00 (GMT-07:00) Mountain Time (US & Canada)
Your Local Time: Fri, Jan 16 2015 00:30 - 04:00
10303 Jasper Avenue
Canadian Western Bank Place - Canadian Room
Analyzing I/O Subsystem Performance
Glenn Berry, Principal Consultant SQLskills
SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage administrator? Are your storage subsystems like a mysterious black box where your databases live but you can’t go visit? This session will get you up to speed with the fundamentals of storage subsystems for SQL Server. You will learn about the different types of storage that are available, and how to decide what type of storage to use for different workload types. You will also learn useful tips and techniques for configuring your storage for the best performance and reliability. We’ll cover methods to effectively measure and monitor your storage performance so that you will have valuable information and evidence available the next time you have to discuss IO performance with your storage administrator. Come to this session to learn how to analyze I/Os as well as options to reduce the bottlenecks.
Glenn Berry works as a Principal Consultant at SQLskills in Parker, CO. He is a SQL Server MVP and has a whole 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, full text search, and SQL Azure.
Glenn is also an adjunct faculty member at University College - University of Denver, where has been teaching since 2000, and has completed the Master Teacher Program at Denver University - University College. He wrote the book "SQL Server Hardware," and blogs regularly at http://sqlserverperformance.wordpress.com.