Best practice for MSSQL on linux?

[killmasta93]

see my screen shot
https://ibb.co/x1SJjZv

 

[LnxBil]

see my screen shot
https://ibb.co/x1SJjZv

What OS did you choose?

 

[killmasta93]

when i choose windows it goes automatically to IDE so i switch to VirtiO but when i choose linux it goes to SCSI. i was reading the wiki and it says to always to use VirtiO
https://pve.proxmox.com/wiki/Performance_Tweaks

Use virtIO for disk and network for best performance.

    Linux has the drivers built in since Linux 2.6.24 as experimental, and since Linux 3.8 as stable
    FreeBSD has the drivers built in since 9.0
    Windows requires the Windows VirtIO Drivers to be downloaded and installed manually

 

[LnxBil]

when i choose windows it goes automatically to IDE

Yeah, but this thread is about Linux, isn't it?

The IDE option works out of the box, VirtIO and VirtIO SCSI do not without having the guest drivers attached on another disk drive and manually installing them. This is hard for firsttime virtualizers, so it is not the default.

it says to always to use VirtiO

VirtIO SCSI is still VirtIO, so it is still true.