Friday, December 30, 2011

Virtualizing Microsoft SQL Server

The SQL performance team has published a document related to the use of SQL 2008 in a Hyper-V environment. A few of the key items are listed in this section, but it is strongly suggested that you download and review this document in its entirety prior to implementing SQL in a Hyper-V environment. To download this SQL team’s document, go to

Use a synthetic network adapter provided by the Hyper-V Integration tools instead of a legacy network adapter when configuring networking for the virtual machine.

Avoid emulated devices for SQL Server deployments when possible. These devices can result in significantly more CPU overhead when compared to synthetic devices. SQL Server is I/O intensive, so it is recommended that you use the pass-through disk option as opposed to the fixed-size Virtual Hard Disks (VHDs). Dynamic VHDs are not recommended for performance reasons.

In the SQL Team’s document, they used locally attached storage on the Hyper-V server. Many virtual hosts are connected to shared storage using Fiber Channel, iSCSI, or NFS. Selecting the proper storage connection will greatly impact the I/O performance of the virtual SQL Server.

Source of Information : Elsevier-Microsoft Virtualization Master Microsoft Server Desktop Application and Presentation

No comments: