Design, Deploy, and Optimize SQL Server on VMware Workshop​

Key Concepts Covered in this Course

Klaus Aschenbrenner

Microsoft Certified Master for SQL Server

I work with Microsoft SQL Server for more than 20 years, and I provide with my company SQLpassion consulting and training services around the whole world.

Since 2012 I’m also a Microsoft Certified Master for SQL Server.

Course Description

Are you desperately searching for faster ways how to run SQL Server on top of VMware vSphere? Do you want to get the best possible SQL Server performance out from your existing VMWare vSphere deployment?

Are you planning to use SQL Server High Availability Technologies (like Failover Clustering or Availability Groups) in combination with VMware vSphere High Availbility technologies (like vMotion, Distributed Resource Scheduler, or even Virtual SAN), and you are not really sure to combine then in a good way?

Info: currently only available on request or as a corporate training!

5/5

Amazing Course

“In this workshop Klaus manages to cover everything you need to know about how to run SQL Server on VMware. With real-life examples it also becomes easy to follow.
I would highly recommend this course to every DBA or developer.”

Mark from Montfoort, Netherlands

Course Details

Course Duration

3 Days

Course Price

On request

Course Level

Intermediate

Agenda & Breakdown

Day 1 – CPU & Memory

  • General Overview
    • Hypervisor
    • ESXi & VMware vSphere
    • VMware Tools
    • ESXTOP
  • CPU Configuration
    • CPU Architectures
    • NUMA Systems
    • Hyperthreading
    • Power Management
  • Memory Configuration
    • Host and Guest Memory Management
    • Locked Pages & Large Pages
    • Memory Reclamation Techniques

Day 2 – Storage & vSAN

  • Storage Configuration
    • Host Datastore Design
    • Guest Storage Design
    • VMDK File Provisioning
    • Troubleshooting Storage Performance
  • Virtual SAN
    • Fundamentals
    • Cache and Capacity Tiers
    • Storage Policies
    • Hybrid vs. All-Flash vSAN
    • Running SQL Server on vSAN
    • Troubleshooting vSAN Performance

Day 3 – HA & Networking

  • High Availability
    • vSphere Clustering
    • vMotion
    • SQL Server Clustering
    • SQL Server Availability Groups
    • Distributed Resource Scheduler
    • VM Anti Affinity Settings
  • Virtual Networks
    • Standard Switches
    • Distributed Switches
    • Uplinks & Downlinks
    • NIC Teaming
    • VLAN Configuration
    • Traffic Shaping
    • Network Card Configuration
    • Troubleshooting Network Performance

Info: currently only available on request or as a corporate training!