locked
Should I Install SQL Server 2008 R2 on a VHDX or Pass-through disk RRS feed

  • Question

  • Hi,

    I am in going to be setting a virtual server running Windows Server 2008 R2 on my Hyper-V cluster and I will be also adding SQL Server 2008 R2 once the OS is configured. Can you please suggest whether I should setup a VHDX or a pass-through disk? I have read articles online suggesting to use a pass-through disk from my SAN but I also read that since Windows Server 2012, VHDX is as good as a pass-through disk, especially because it will allow to have snapshots taken, unlike the pass-through which will not.

    Please advise on whether I should chose a pass-through disk or a VHDX.

    Thanks in advance,

    Thursday, September 4, 2014 10:04 PM

Answers

  • Hi Aquila,

    There are three basic types of Virtual Hard Disks (VHDs) that you can use with VMs, such as dynamic VHD, fixed VHD, and differencing disks. Usually, the fixed VHD is almost always the best choice for virtualized SQL Server systems that run a production workload. You can use dynamic disks for noncritical production workloads, as well as for testing, training, and lab environments. Pass-through disks offer the highest level of performance for VM storage, however, Pass-through disks can't be moved without incurring downtime, and they don't support VM snapshots. For more information, seehttp://sqlmag.com/sql-server/sql-server-virtualization-tips

    In addition, there is an article about how to setup boot from VHD for a SQL Server. You can review the following link.

    http://www.mssqltips.com/sqlservertip/2327/how-to-setup-boot-from-vhd-for-a-sql-server-test-or-development-environment/

    Regards,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    • Proposed as answer by Saeid Hasani Saturday, September 13, 2014 4:43 AM
    • Marked as answer by Saeid Hasani Saturday, September 13, 2014 4:43 AM
    Friday, September 5, 2014 9:27 AM