Design, Deploy, and Optimize SQL Server on VMware Workshop
Key Concepts Covered in this Course
- CPU & Memory Configuration
- Storage Management
- VMware vSAN for SQL Server
- High Availability Options
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!
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!
