Skip to content

Virtually Caffeinated

A double-shot of knowledge

Menu
  • About Me
  • Bookmarks
  • Innovative Store

About Me

Profile
Jeremy Wheeler

I am a Solutions Architect with 30+ years in IT, specializing in cloud architecture, virtualization, and multi-cloud platforms like AWS, Azure, and Google Cloud. I’ve led enterprise projects like VMware’s Horizon Suite Sizing Estimator and have extensive experience with VMware Horizon, Citrix, Hyper-V, and programming languages like PowerShell, Python, and SQL. I run Smart AI Coach (https://smartaicoach.com/), helping individuals leverage AI for resumes, cover letters, and productivity. As a published author, VMware vExpert (2015-2020), and MIT-certified in AI, I am passionate about innovation and solving challenges.

  • Home
  • 2015
  • May
  • 5
  • SQL Server or Normal VM behavior for HA
Omnissa Horizon View

SQL Server or Normal VM behavior for HA

Jeremy Wheeler
May 5, 2015July 1, 2015 1 min

In the event your organization is considering maintaining a SQL server on a Stretched Management cluster (Metro Cluster) or normal cluster please keep in mind the following:


  1. Normal Operations
  2. Host fails and dedicated resources of vCPU, RAM, are now unavailable
  3. Admission Control triggers an HA event 
  4. Virtual Machine is power cycled-down
  5. DRS migrates Virtual Machine to surviving host in the cluster
  6. Virtual Machine is powered-on based on power policy 

Step 4, 5, 6 would cause an outage unless the SQL DB is clustered. Stretched storage only
will help for migration between hosts but dedicated compute resources to VMs will still cause an outage. 

Even placing a stretched storage solution in a cluster doesn’t magically maintain a fully powered on VM. If you steal the compute resources from anything it’s going to have a bad time. The only way around this would be to setup VMware’s FT where everything is mirrored between Host A and Host B.

Share :
whosay

Written by  Jeremy Wheeler: Jeremy

I am a seasoned Solutions Architect with over 20 years of expertise in IT, specializing in cloud architecture, virtualization, and end-user computing solutions. My career highlights include working with top-tier technologies across multi-cloud platforms such as AWS, Azure, and Google Cloud. I have a proven track record of leading complex enterprise projects, including the development of tools like VMware’s Horizon Suite Sizing Estimator, which optimized hardware prediction accuracy for customers worldwide. With hands-on experience in virtualization technologies like VMware Horizon, Citrix, and Hyper-V, I excel in designing, deploying, and optimizing full-lifecycle solutions. My technical depth is complemented by 18 years of computer programming experience in PowerShell, Python, C++, .NET, SQL, and more. I am a published author and have contributed to industry literature, including works on desktop virtualization and user environment management. Recognized as a VMware vExpert for six consecutive years (2015-2020), I’ve also received multiple awards for excellence, such as VMware Spotlight and Our Best accolades. Currently, I leverage my knowledge to deliver innovative solutions, combining strategic insights and cutting-edge technologies like AI, as evidenced by my recent certification from MIT. Above all, I thrive on solving challenges and empowering teams to exceed customer expectations.

Post navigation

Previous: App Volumes Maximums
Next: VMware Horizon Maximums

Related Post

vIDM and Horizon Blast/Client Oddity

Instant Clones and GPO Enforcement

Top 20 Horizon with View KB articles

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Categories

Recent Posts

  • Preventing Hallucination in AI: A Guide Based on Industry Standards
  • Clash of the AI Titans: Gemini 2.5 vs. ChatGPT-4o – Which Reigns Supreme?
  • VMware Explore 2025: Shaping the Future of Multi-Cloud and Edge Technologies
  • AI Trends Shaping the Future in 2025
  • Omnissa vApp and AI: Transforming Application Delivery in 2025

Archives

RSS Press Releases

Copyright VMBUCKET.COM © 2020