Here is the abstract for my 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.
Here is a link to the PDF version of my presentation.
I was actually a last-minute substitution speaker for this meeting, and I was happy that I could help!
We actually did get a big turnout for the event. The Denver SSUG does a good job with their meetings, and they are a lot of fun. It is always a good idea to try to attend your local user’s group meetings, since you are likely to learn something and it is a very good opportunity to network.
If you are a SQL Server UG organizer, you might be interested in knowing that SQLskills has a number of speakers that regularly do remote presentations for user groups around the world. If you are interested in having one of us speak remotely at your event, please drop an e-mail to firstname.lastname@example.org