SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Future Virtual Machines

By Steve Jones,

I recently virtualized my Windows Home Server. I have had multiple boot drive failures, and I was getting tired of reinstalling the product. So I installed VirtualBox, then created a series of virtual disk drives and set my home server back up. It's built on RAID 1 drives, so I'm hoping that it will last a long time, and even migrate to newer hardware over time.

On my laptop and desktop, I use VMWare to build test machines, and then use them for various versions of SQL Server in presentations. I can easily make changes in a VM on the desktop, copy the VHD files to my laptop, and then have the same environment ready when I deliver a presentation. Over the last ten years, virtualization has become a fantastic test environment for me and I can't imagine doing without it. On the server side, I haven't even noticed the migration of the SQLServerCentral servers from physical hosts to virtual machines, and they have performed very well.

However in one sense, nothing has changed for me on the server side. Our VMs are over provisioned, to prevent issues with the performance, just as they often were with physical machines. I suspect that is the case with many other virtual SQL Servers out there in production. However I'm not sure it's a bad way to deploy VMs for a database server, especially with hardware so cheap.

I ran across a series of reports on the hypervisors of the future, which talks about the changes from the various vendors, and has a large section devoted to desktop hypervisors. It's an interesting read, though quite a bit of the information is related to open source products. On the Windows 8 front, the Hyper-V changes look good, but I worry that licensing might prevent most of us from taking advantage of the enhancements. 

I find virtualization to be an amazing way to get more work done on a desktop, in a very stable manner. I can test software in a VM and then remove it, or delete the host if the software causes issues. I can also simulate a large amount of hardware with much less effort than in the past. I urge you to try some virtualization software and experiment with the capabilities. Whether you build experience by working with software you can't install elsewhere, or just learn some of the capabilities of the virtualization software, it will help you at some point in your career. I only expect there to be more and more VM deployment in all companies over the next decade.

Steve Jones

The Voice of the DBA Podcasts

My apologies. A glitch in the matrix resulted in no podcasts today. We will be back tomorrow with the show.

You can follow Steve Jones on Twitter:

Total article views: 321 | Views in the last 30 days: 3
Related Articles

Change User Desktop Folder Path by Using PowerShell

We could change your desktop folder location by using the following powershell script. Actually we n...


desktop engine 2000 versus SQL 2000 server

desktop engine 2000 versus SQL 2000 server


How to Performance Tune a VLDB on your Desktop

Recently, I wrote a review of Red Gate Software’s new SQL Virtual Restore software. SQL Virtual Rest...


Rogue Software Changes

Today Steve Jones wonders if software developers would make changes to software on their own, withou...


Other Desktops

The USB not in Hyper-V thing is annoying. It actually made me stop and consider my alternatives for ...