Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask great questions, I thought I’d extend an offer to everyone at the European show coming up in a week! Let’s talk SQL Server! We are going to crash the VMvillage hang space on Tuesday, September…
Category: VMWare
SQL Server on VMware VMworld USA Videos Now On YouTube
I just realized that our two SQL Server on VMwaresessions that I co-presented on Tuesday at VMworld USA, both of which made the top 10 sessions of the day list at the conference, are now on YouTube! They are free to watch for everyone! For those of you with virtualized SQL Servers, regardless of platform and cloud or…
VMworld EMEA SQL Server Sessions
This trip to Barcelona for the next VMworld EMEA conference next week will be my second trip to this conference in two years. I’m ecstatic to get there and start talking SQL Server content with folks! I’m presenting on SQL Server performance, scalability, and monitoring in three sessions at this conference. Tuesday 11am – Monster…
VMworld 2017 SQL Server Sessions
Just a reminder – our SQL Servers sessions for this year’s VMworld 2017 conference in Las Vegas are starting to fill up! I have four exciting sessions (if you’re a database geek) at the conference, and for those DBAs with VMware administrators attending this conference, tell them to attend these sessions so they can help…
New Whitepaper – Capture Production Error States
System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to minimize the impact to the business. You are caught in a difficult decision. Do you repair the VM as quickly as possible, but possibly lose traces of what went wrong. In doing so, that loss of…
Keep VMware snapshot growth from wrecking your day
VM snapshots are one of the best virtualization features ever. But…have you ever had a VMware vSphere or Hyper-V snapshot grow out of control and fill the datastore the VM resides on? You know what happens… even the best VM admins out there seem to get burned once when they create a snapshot for some…
Updated SQL Server on VMware Best Practices Guide
I am proud to announce that we contributed to the latest revision of the Microsoft SQL Server on VMware best practices guide, freely available at this address. This document outlines some of the common VM-level tweaks and adjustments that are made when running enterprise SQL Server VMs on VMware platforms. This guide is considered a must-read…
VMware Updates In-Guest Clocks When You Say Not To
VMware’s VMTools package has some options for synchronizing the in-guest clock with the time of the ESXi host. By default, these are set to disabled, and under most circumstances, the hypervisor follows these settings and everything is fine. However, several situations exist where the hypervisor will reset the in-guest time, even though the VMTools setting…
VMware vSphere 6.5 breaks your SQL Server vNUMA settings
VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine, and there’s a high likelihood that it will break your virtualized SQL Server vNUMA configuration and lead to unexpected changes in behavior. It might even slow down your SQL Servers. Here’s what you need to…
VMware CPU Co-Stop and SQL Server Performance (continued)
A number of you sent me some excellent questions about this topic, and my favorite asked me for the query that you can use to get this information DIRECTLY from the VMware vCenter database. SO… here you go! Just plug in your VM name (which might differ from your FQDN name). Feel free to modify…