Meeting – March 19, 2020
Given the news about the Covid-19 virus, the Denver SQL group is following recommendations and we will host the March 19th meeting via webinar and not in person. We are working on setting up the webinar and will send out connection details once we have everything setup.
Please join the meeting from your computer, tablet or smartphone.
You can also dial in using your phone.
United States: +1 (408) 650-3123
Access Code: 539-646-717
Join from a video-conferencing room or system.
Dial in or type: 22.214.171.124 or inroomlink.goto.com
Meeting ID: 539 646 717
Or dial directly: email@example.com or 126.96.36.199##539646717
New to GoToMeeting? Get the app now and be ready when your first meeting starts:
6:00 – 6:15 User Group Business
6:15 – 7:15 Main presentation
Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance
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 magnetic and SSD 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.
By Glen Berry
Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he 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, performance tuning, and Azure SQL Database. 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 heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware, and he wrote chapters for SQL Server MVP Deep Dive and SQL Server MVP Deep Dives Volume 2 books. Glenn blogs regularly at https://glennsqlperformance.com/. He is active on Twitter as @GlennAlanBerry.