Doing It Wrong: Virtualizing SQL Server

Doing It Wrong: Virtualizing SQL Server

I’ve been involved in a virtualization projects for almost ten years now. In that time I’ve had the opportunity to track my own list of “best practice” items. It’s a list I share freely with clients and customers that seek me out for virtualization advice. I can tell that virtualization (and Cloud) efforts are on … Read more

Administering SQL Server 2012 Running On Windows Server Core

Are you afraid of deploying (or supporting) an instance of Windows Server Core? Are you telling others to “stay away” because of your own fears of doing something new? Then I am here to tell you that you’re doing it wrong. Last month I decided that it was time to get down and dirty with … Read more

TPC-VMS Benchmark To Compare Virtual Workloads

This past November the Transaction Processing Performance Council (the TPC) released a new benchmark, the TPC-VMS. If you are interested in the details you can download the PDF by clicking here. The TPC benchmarks have been the industry standard when it comes to benchmarking database performance. As more companies move towards virtualization solutions the standard TPC … Read more

VMWare KB: An Incomplete List of Tips for Configuring Microsoft SQL Server in a Virtual Machine

I wanted to take a moment to point out this VMWare KB article I came across recently. I really do love how the KB article points out the need for accurate disk configurations. I often see misconfigured disks resulting in a performance bottleneck for a virtualized environment. So that part of the KB was great for me to see … Read more

Stop Guessing About CPU Pressure

Ever try to troubleshoot something that doesn’t really exist? I think this virtualization thing is here to stay, I really do, but the trouble I see people having with virtualization is that they don’t know where the bottleneck truly lies. There are so many layers involved that most standard troubleshooting techniques fall short. Just think … Read more