This always makes for interesting IT Pro discussions … Best practices for virtualizing heavy-duty application workloads, such as large SQL Server installations. With the launch of Windows Server 2012, we've greatly improved the ability to allocate large amounts of compute, network and storage resources to virtual machines. As a result, more and more environments are looking back at the workloads that they had previously considered "un-virtualizable", and they are now planning to migrate them into virtualized Private Clouds in their datacenter to gain better management control, physical resource utilization, and time/cost savings.
Recently, I spoke at the local Professional Association for SQL Server (SQLPASS) user group in Northern Ohio on the topic of "Virtualizing SQL Server with Windows Server 2012 & Hyper-V". It was a well-attended event with lots of interest in how best to take advantage of the new features in Windows Server 2012 for virtualized SQL Server database instance workloads. Below, I've provided a copy of my deck along with key discussion points. At the end of this article, I've also included a list of additional resources that I've found helpful when virtualizing SQL Server instances in my own projects.
---- cut here ----
Download this deck for offline viewing.
This presentation is organized into three sections below:
Start Your Journey!
Ready to try this out in your own lab?
Be sure to check out these additional resources:
Keith Mayer is a Principal Technical Architect at Microsoft, focused on helping ISV partners leverage the Azure cloud platform. Keith has over 20 years of experience as a technical leader of complex IT projects, in diverse roles, such as Network Engineer, IT Manager, Technical Instructor and Consultant. He has consulted and trained thousands of customers and partners worldwide on design of enterprise technology solutions.
Keith is currently certified on several Microsoft technologies, including Azure, Private Cloud, System Center, Hyper-V, Windows, Windows Server, SharePoint, SQL Server and Exchange. He also holds other industry certifications from VMware, Amazon AWS, IBM, Cisco, Citrix, HP, CheckPoint, CompTIA and Interwoven.
You can contact Keith online at http://aka.ms/AskKeith.