(If you’re having persistent problems with your virtual machine configurations and SQL Server performance, Jonathan can help you fix it – fast! Click here for details.) In the last month I have had to explain how to interpret CPU Ready Time information for SQL Server VMs running on VMware to a number of people. The [...]
Jonathan Kehayias
The Rambling DBA
CPU Ready Time in VMware and How to Interpret its Real Meaning
Posted on: November 29, 2012 2:00 pm
Clustering SQL Server on Virtual Machines (Round 2)
Posted on: November 29, 2012 1:38 pm
Recently there was lengthy discussion on the #sqlhelp hash tag on Twitter about clustering SQL Server on VMs and whether or not that was a good idea or not. Two years ago I first blogged about this same topic on my blog post, Some Thoughts on Clustering SQL Server Virtual Machines. If you haven’t read [...]
Fixing VirtualBox “Could not find an open hard disk with UUID” Errors with Differencing Disks
Posted on: June 13, 2012 9:48 am
A few weeks back, I needed to make space on my laptop SSDs for some new VMs for future training classes we’ll be doing and as a part of doing this I decided to copy a number of my VirtualBox VMs to an external hard disk. What I had expected was that this would work [...]
How much memory does my SQL Server actually need?
Posted on: April 3, 2012 1:00 pm
Traditionally questions about how much memory SQL Server needs were aimed at how to appropriately set the 'max server memory' sp_configure option in SQL Server, and in my book the recommendation that I make is to reserve 1 GB of RAM for the OS, 1 GB for each 4 GB of RAM installed from 4–16 [...]
SQL Server and VMware: A Potentially Fatal Combination? That’s Nonsense!
Posted on: September 30, 2011 2:09 pm
This morning Paul received an email from a member of the community that was asking if it is safe to run SQL Server inside of a VM and whether we would suggest running databases in virtual machines or not. The root of the question being asked was an article that the person had read back [...]
Some Thoughts on Clustering SQL Server Virtual Machines
Posted on: November 24, 2010 9:19 pm
On my blog post Virtualizing SQL on VMware Reference List, Oscar Zamora (Blog | Twitter) asked the following question in a comment: As a virtualized instance has the benefit of "failing over" to another physical box, would you consider clustering a virtualized instance? The answer to this question more than I want to write up [...]
Virtualizing SQL on VMware Reference List
Posted on: November 22, 2010 9:15 pm
I’ve been managing SQL Server virtualized in production environments for nearly five years now, and in that time, I’ve had to do a significant amount of reading/learning about VMware as a hypervisor so that I could properly track down performance problems and in a lot of cases, prove to vendors that the problem wasn’t virtualization. [...]
