MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server 2012: Evaluating and Sizing Hardware

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 Syllabus

    - 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 41s
    Choosing 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 49s
    Choosing the Correct Processor for SQL Server 2012
    - 29m 37s
    SQL Server 2012 Editions and License Limits
    - 12m 53s
    Choosing an Appropriate Storage Type for SQL Server 2012
    - 25m 30s
    Hardware and Storage Sizing Techniques
    - 19m 22s
    Choosing Components for Redundancy
    - 10m 54s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url