The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Login to Subscribe

Meeting Details
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance - Glenn Berry

Tue, May 07 2019 16:00 UTC

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance - Glenn Berry

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in flash storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from Intel and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads. Glenn 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.


Glenn Berry

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

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids