SQL Server 2012: Evaluating and Sizing Hardware
Pluralsight
Course Summary
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.
-
+
Course Description
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.
-
+
Course Syllabus
Introduction- 16m 40s
—Introduction 1m 33s
—Why Hardware Selection is So Important 1m 13s
—The Importance of Processor Selection 1m 32s
—Main SQL Server 2012 Editions 1m 55s
—Additional SQL Server 2012 Editions 1m 16s
—Licensing Costs for SQL Server 1m 17s
—Choosing an Appropriate Storage Type 1m 35s
—The Importanace of Proper Selection and Sizing 1m 30s
—Hardware and Storage Sizing Techniques 1m 55s
—Selecting Components for Redundancy 1m 11s
—Summary 1m 2s
—Course Structure 0m 41sChoosing the Correct Hardware for Your Workload- 15m 8s
—Introduction 0m 49s
—SQL Server Workload Types 1m 22s
—OLTP Workloads 1m 15s
—DW/DSS Workloads 1m 22s
—OLAP Workloads 1m 7s
—Mixed Workloads 1m 35s
—Database Maintenance Workloads 1m 19s
—Database Backup Workloads 1m 18s
—Database Restore Workloads 1m 12s
—Effects of HA/DR Technology on Workload 1m 6s
—Workload Size and Intensity 1m 4s
—Summary 0m 50s
—What is Next? 0m 49sChoosing the Correct Processor for SQL Server 2012- 29m 37sSQL Server 2012 Editions and License Limits- 12m 53sChoosing an Appropriate Storage Type for SQL Server 2012- 25m 30sHardware and Storage Sizing Techniques- 19m 22sChoosing Components for Redundancy- 10m 54s
