Bhyve and Microsoft SQL

[Rickinfl]

Hi, Did they ever fix it where VM Bhyve would run Windows Server and SQL Server? It's been a while since I've checked but it has something to do with Bhyve not able to run 512 blocks that are required by MS SQL.

Thanks

 

[Matt84]

I run MS SQL 2017 and then upgraded to 2019 via a CentOS 7 VM and have had no issues. I left the block size to the defaults when creating the VM so I'm not sure what it is set to though.

 

[blanchet]

MS SQL Server supports only 512-bytes and 4096-bytes sectors.

You can force the sector size of the disk in the Device section of the virtual machine
the three options are for Disk sector size are

• default
• 512
• 4096

According to my experience:

• In the past when bhyve virtio vdisk did not work with Windows Server, you had to use AHCI vdisk with 512 bytes sectors to run MS SQL Server
• But for few years, virtio vdisks works well with Bhyve and Windows server, and you can even keep the default: it works.
• Nevertheless, it is safer to specify a value for the vdisk (prefer 4096), otherwise you may wonder that is the default value