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: Virtualization

Course Summary

Virtualization of SQL Server instances have become very popular in IT infrastructures, but it's very common to see misconfigured virtual machines resulting in severe performance problems of the SQL Server workloads. This course will show you how to proper


  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Why am I teaching this course?
        ◦ Course Expectations
        ◦ Virtualization Support
        ◦ Course Structure
    ● How Virtualization Works
        ◦ Introduction
        ◦ CPU Virtualization
        ◦ x86 Architecture Levels of Privilege
        ◦ Virtual Machine Monitor (VMM)
        ◦ Hardware Virtualization
        ◦ Soft Memory Virtualization
        ◦ Summary
    ● Why Virtualization is Popular
        ◦ Introduction
        ◦ Virtualization is Cheaper
        ◦ Lower Total Cost of Ownership
        ◦ Simplified Disaster Recovery
        ◦ High Availability is Built-In
        ◦ Reposition IT as a Utility
        ◦ Summary
    ● SQL Server Considerations
        ◦ Introduction
        ◦ Determining VM Candidates
        ◦ How Non-DBAs View SQL Servers
        ◦ The Reality of SQL Server
        ◦ Understanding SQL Server Memory Requirements
        ◦ SQL VM CPU Considerations
        ◦ VM Storage Planning
        ◦ VM Storage Planning (2)
        ◦ Providing Direct SAN Access to VMs
        ◦ Summary
    ● Virtual Machine Resource Configuration
        ◦ Introduction
        ◦ Determining vCPU Count
        ◦ SQL VM CPU Allocations
        ◦ CPU Co-Scheduling
        ◦ CPU Co-Scheduling Types
        ◦ CPU Co-Scheduling Problems
        ◦ VMware CPU Ready Time
        ◦ VM Sizing Considerations
        ◦ VM Sizing Considerations (2)
        ◦ Virtual NUMA (vNUMA) Configuration
        ◦ vNUMA Optimized Configuration
        ◦ Ensuring VM Resource Allocations
        ◦ Hyper-V CPU Reserve
        ◦ VMware CPU Reservation
        ◦ Hyper-V CPU Relative Weight
        ◦ VMware CPU Shares
        ◦ Hyper-V Dynamic Memory
        ◦ Implications of VMware Memory Overcommit
        ◦ VMware Memory De-Duplication
        ◦ VMware Balloon Driver
        ◦ VMware Best Practices for SQL Server
        ◦ Summary
    ● High Availability and Disaster Recovery
        ◦ Introduction
        ◦ Virtualization High-Availability Basics
        ◦ VMware Fault Tolerance
        ◦ Hyper-V Replicas
        ◦ Hyper-V Replica Limitations
        ◦ SQL Server High-Availability Options
        ◦ Virtual Machine Failover Clustering
        ◦ Database Mirroring and Availability Groups
        ◦ Summary
    ● Backing Up SQL Server Virtual Machines
        ◦ Introduction
        ◦ Virtual Machine Backup Solutions
        ◦ Problems with VM Backups
        ◦ SQL Server Backup
        ◦ Summary
    ● Monitoring Performance
        ◦ Introduction
        ◦ Understanding % Processor Time in a VM
        ◦ Monitoring on VMware
        ◦ VMware Host Counters (esxtop)
        ◦ Virtual Center
        ◦ vCenter CPU Ready Summation


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