http://www.sqlservercentral.com/blogs/glennberry/2010/11/11/hardware-201_3A00_-selecting-and-sizing-database-hardware-for-oltp-performance/

Printed 2014/07/25 08:29AM

Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

By GlennBerry, 2010/11/11

I will be presenting my session on hardware selection and sizing today at 10:15AM in Room 608 at the PASS 2010 Summit. It will be the first session after the keynote address, and I will be going against some very well known and popular speakers in other tracks, so hopefully I will not be talking to an empty room. We will seeā€¦

Here is the session information.

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 both Intel and AMD and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

Here is one of my favorite free tools for hardware identification, CPU-Z.

image


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.