Using Microsoft Hyper-V for SQL Server consolidation

With Windows Server 2008 Hyper-V and the upcoming release of R2, Microsoft is driving full speed ahead towards server virtualization. Their efforts are not only limited to Hyper-V, either. In fact, Microsoft has begun to produce applications — server applications, specifically — that are designed to be virtualized.

These virtualization offerings are now fully supported either on Windows Server 2008 Hyper-V, Windows Hyper-V Server or any other hardware virtualization platform that has undergone certification through the Server Virtualization Validation Program (SVVP). Currently, certified vendors for SVVP include VMware, Citrix, Novell and Cisco, though VMware was the first to achieve this level of certification.

With this move towards virtualization suppo...

RELATED CONTENT Microsoft SQL Server Consolidation and Virtualization Is interest in SQL Server virtualization on the rise? Q&A: SQL Server 2008 a better fit for consolidation Deploying a SQL Server virtual appliance for Microsoft Hyper-V How to create SQL Server virtual appliances for Hyper-V Protect virtual databases through SQL Server database mirroring Maintaining high availability of SQL Server virtual machines Creating fault-tolerant SQL Server installations The challenges of SQL Server consolidation SQL Server Consolidation Fast Guide SQL Server consolidation strategies and best practices Microsoft SQL Server Consolidation and Virtualization Research SQL Server Migration Strategies and Planning CTP released for MySQL migration toolkit Making sense of Parallel Data Warehouse for SQL Server 2008 R2 SQL Azure officially becomes paid service eZines and eBooks for SQL Server professionals New SQL Server 2008 R2 CTP set for November PASS Summit 2009 Preview Are data warehouses made for the cloud? Q&A: Moving forward with SQL Server in the cloud SQL Server Mailbag: Migrating down to Standard Edition Microsoft releases SQL Server 2008 R2 CTP Database Management and Administration Database encryption in SQL Server 2008: Improvements you finally need Common oversights with SQL Server security audits Top 5 SQL Server DBA tasks that are a waste of time Password cracking tools for SQL Server Using traces in SQL Server Profiler Meet compliance requirements with improved database security practices Hardening the network and OS for SQL Server security Securing the server and database in SQL Server How SQL Server 2008 components impact SharePoint implementations Troubleshooting Distributed Transaction Coordinator errors in SQL Server

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

rt, more and more Microsoft server products will be designed specifically with virtualization of the workload in mind. This is the case for SQL Server 2008, among others. When you run SQL Server 2008 on Windows Server 2008 inside a virtual machine (VM), you stand to gain several advantages:

• First and foremost, you can consolidate your existing and future databases. Depending on its configuration, each SQL Server virtual machine can run any number of databases.
• You can also support further consolidation by creating multiple SQL Server instances inside each virtual machine.
• While older versions of SQL Server can be virtualized, they are not optimized for virtualization. With SQL Server 2008, Microsoft has enhanced the code to take advantage of virtualization through tight integration with virtual system drivers.
• You should run SQL Server 2008 on Windows Server 2008 to obtain the very best performance in virtual machines. As stated earlier, Windows Server 2008 is designed as a virtualization-aware operating system from the ground up. Older operating systems such as Windows Server 2003 and even Windows 2000 Server have also been optimized for virtualization, but this has been done through the application of service packs, not the design of the code from the ground up.
• Running SQL Server 2008 on Windows Server 2008 will let SQL Server take full advantage of the synthetic drivers included in the operating system. When you run both on top of Hyper-V, the virtual machine will be able to run as an enlightened guest and directly access virtualized hardware through Hyper-V's VMBus, taking full advantage of the Hyper-V platform.

The advantages of virtualization are undeniable. Each hard disk drive for the VMs is contained within a virtual hard drive — drives that are contained in files on the physical disk — which makes them very easy to back up, duplicate or replicate. In addition, running SQL Server within virtual machines supports complete and absolute isolation among all database instances, yet lets you take full advantage of powerful new x64 hardware by running several virtual machines. Better yet, running SQL Server on hardware virtualization engines such as Hyper-V is now fully supported.

Server virtualization is here to stay and even demanding workloads such as SQL Server 2008 can take advantage of this new operational model with little or no performance loss. If you are deploying SQL Server 2008, you should seriously consider this model as a perfect way to consolidate your databases.

Next up: Creating fault-tolerance virtual installations COMING SOON!

[IMAGE][IMAGE]Danielle Ruest and Nelson Ruest are IT professionals specializing in systems administration, migration planning, software management and architecture design. Danielle is Microsoft MVP in Virtualization and Nelson is Microsoft MVP in Windows Server. They are authors of multiple books, including the free Definitive Guide to Vista Migration for Realtime Publishers and Windows Server 2008: The Complete Reference for McGraw-Hill Osborne. For more tips, write to them at info@reso-net.com.