I am thinking of either running MSSQL 2008 on a bare metal machine or in a Ubuntu Guest based KVM virtual machine. The server itself is quite well provisioned.
I want to use KVM, but my primary concern is the disk I/O - directly vs through the KVM based VM.
Does anyone know:
- If the I/O performance is comparable?
- Are there any drivers that make win 2008 perform better on a KVM or are these already part of the KVM base virtualization?
- Any tools/scripts/command I can run to compare my bare metal I/O thoughput to that via the VM.
Any other advise would be welcome...relatively new to this :)