Options

I/O speed in Virtualization

GrynderGrynder Member Posts: 106
in Virtualization
As I am studying for my MS 70-431 certification I have come up with a question that hopefully some of the virtualization experts can help me with.
It is possible to install a database on multiple filegroups located on multiple physical drives to increase read access because by using multiple drives you have multiple read/write heads to look up data.
If I install SQL server in a virtual environment and use multiple virtual hard drives in the virtual machine would I still get the same increase in read access as I would if I used multiple physical drives?
I think no, because the virtual machine is physically located on 1 drive. So there is only one read/write head.

Thanks for any input.
· Share on FacebookShare on Twitter

Comments

  • Options
    dynamikdynamik Banned Posts: 12,312 ■■■■■■■■■□
    You could put the virtual HDs on different physical HDs/RAID arrays though.
    · Share on FacebookShare on Twitter
  • Options
    blargoeblargoe Member Posts: 4,174 ■■■■■■■■■□
    That's right, unless there's the physical separation, you're gaining nothing.
    IT guy since 12/00

    Recent: 11/2019 - RHCSA (RHEL 7); 2/2019 - Updated VCP to 6.5 (just a few days before VMware discontinued the re-cert policy...)
    Working on: RHCE/Ansible
    Future: Probably continued Red Hat Immersion, Possibly VCAP Design, or maybe a completely different path. Depends on job demands...
    · Share on FacebookShare on Twitter
  • Options
    GrynderGrynder Member Posts: 106
    Thanks for the input.

    "You could put the virtual HDs on different physical HDs/RAID arrays though."

    I did not know this was an option. I looked into it and it seems like a straight forward process.
    · Share on FacebookShare on Twitter
Sign In or Register to comment.