Best practice for MSSQL on linux?

killmasta93

Member
Aug 13, 2017
458
16
18
25
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

Code:
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

Well-Known Member
Feb 21, 2015
3,951
367
83
Germany
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.
 
  • Like
Reactions: killmasta93

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE and Proxmox Mail Gateway. We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get your own in 60 seconds.

Buy now!