Learn how to correctly choose server hardware for SQL Server 2012, including workload evaluation, SQL Server 2012 Edition hardware limits and licensing costs, processor and storage choice, and redundancy components and effects. This course is applicable to anyone who is purchasing hardware for SQL Server for the first time and wants to avoid the common mistakes and pitfalls that are made so often.
How do you choose a processor? Which Edition of SQL Server 2012 should you select? How do you choose a RAID level for the SQL Server storage? How do you compare processor performance using benchmarks? This course answers all these questions and more. The course begins by explaining why it is so important to choose server hardware for SQL Server 2012 correctly, and then explains how to categorize your workload and the hardware requirements of the common SQL Server workloads. It then explains how to choose a processor based on your server configuration, as well as how to compare the performance of processors, as well as the various SQL Server 2012 Editions and their license limits. Next it explains the various storage types, RAID levels, and how to test the performance of your storage, along with comparing overall server performance and considerations around the amount of memory to use. Finally it discusses the effects on hardware choice of high-availability and disaster-recovery strategies, along with hot-swappable components to increase uptime. This course is perfect for anyone who is purchasing hardware for SQL Server for the first time and needs guidance on how to properly make decisions to get the return on investment from SQL Server 2012 license costs and server hardware and storage costs.
Glenn works as a Principal Consultant at SQLskills.com. He has been a SQL Server MVP since 2007, and he is also an Adjunct Faculty member at University College - University of Denver. He is the author of the book SQL Server Hardware (Redgate 2011), and he wrote chapters for both SQL Server MVP Deep Dives books.