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

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 Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Why Hardware Selection is So Important
        ◦ The Importance of Processor Selection
        ◦ Main SQL Server 2012 Editions
        ◦ Additional SQL Server 2012 Editions
        ◦ Licensing Costs for SQL Server
        ◦ Choosing an Appropriate Storage Type
        ◦ The Importanace of Proper Selection and Sizing
        ◦ Hardware and Storage Sizing Techniques
        ◦ Selecting Components for Redundancy
        ◦ Summary
        ◦ Course Structure
    ● Choosing the Correct Hardware for Your Workload
        ◦ Introduction
        ◦ SQL Server Workload Types
        ◦ OLTP Workloads
        ◦ DW/DSS Workloads
        ◦ OLAP Workloads
        ◦ Mixed Workloads
        ◦ Database Maintenance Workloads
        ◦ Database Backup Workloads
        ◦ Database Restore Workloads
        ◦ Effects of HA/DR Technology on Workload
        ◦ Workload Size and Intensity
        ◦ Summary
        ◦ What is Next?
    ● Choosing the Correct Processor for SQL Server 2012
        ◦ Introduction
        ◦ Workload Type and Size Considerations
        ◦ Determining Your Server Form Factor
        ◦ Overall Budget Considerations
    ● SQL Server 2012 Licensing Considerations
        ◦ The Importance of Single-Threaded Performance
        ◦ The Importance of Total Core Counts
        ◦ Intel or AMD Processors?
        ◦ Intel Tick Tock Release Strategy
        ◦ Current Intel Server Processor Series
        ◦ Recommended Intel Two-Socket Processors
        ◦ Recommended Intel Four-Socket Processors
        ◦ TPC-E Benchmark Introduction
        ◦ Using TPC-E Benchmarks to Evaluate Processors
        ◦ TPC-E Score Analysis Examples
        ◦ Geekbench Benchmark Introduction
        ◦ Using Geekbench to Compare Processors
        ◦ Selected Geekbench Scores
        ◦ Processor Power Efficiency Considerations
        ◦ Summary
        ◦ What is Next?
        ◦ SQL Server 2012 Editions and License Limits
        ◦ Introduction
        ◦ Licensing Costs for SQL Server 2012
        ◦ SQL Server 2012 Standard Edition
        ◦ SQL Server 2012 Business Intelligence Edition
        ◦ SQL Server 2012 Enterprise Edition
        ◦ SQL Server 2012 Developer Edition
        ◦ Additional SQL Server 2012 Editions
        ◦ SQL Server 2012 Virtualization Licensing
        ◦ Summary
        ◦ What is Next?
    ● Choosing an Appropriate Storage Type for SQL Server 2012
        ◦ Introduction
        ◦ Considering Your Wokload for Storage
        ◦ Additional Workload Considerations
        ◦ Choosing the Storage Type for SQL Server
        ◦ RAID Basics
        ◦ RAID 1
        ◦ RAID 5
        ◦ RAID 50
        ◦ RAID 10
        ◦ Raid Level and SQL Server Workloads
        ◦ Testing Your Logical Drive Performance
        ◦ CrystalDiskMark 3.0.1 x64
        ◦ SQLIO Disk Benchmark
        ◦ Magnetic Storage vs. Flash-Based Storage
        ◦ PCI-E Numbers to Know
        ◦ Traditional Magnetic Drive Performance
        ◦ Consumer Flash Drive Performance
        ◦ Storage Sizing Techniques for Performance
        ◦ Summary
        ◦ What is Next?
    ● Hardware and Storage Sizing Techniques
        ◦ Introduction
        ◦ Comparing Servers Using TPC-E
        ◦ Comparing Servers Using TPC-H
        ◦ Comparing Servers Using Geekbench
        ◦ Adjusting Benchmark Scores for Different Processors


    Course Fee:
    USD 29

    Course Type:

    Self-Study

    Course Status:

    Active

    Workload:

    1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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

Back to Top