MSSQL Fail to start on newer hardware

Published Date: 2022/03/31 by: DaVieS

I recently faced with a strange issue with Microsoft Database Server.
I used Bhyve as hypervisor and a Windows as Guest OS, tried to install MSSQL but failed with very "speaky" errors below...

SqlEngineDBStartConfigAction_install_configrc_Cpu64
SqlEngineDBStartConfigAction_install_configrc_Cpu32

during installation.

I tried to run it manually and it just exited with fault after saying:
There have been X misaligned log IOs which required falling back to synchronous IO. The current IO is on file xxx. - Thats something... After seeking for answers all I got is just a hint about newer SSDs and try to install another drive as a solution. So every mostly useless forum post get me closer to the conomdrum.

So what is the common thing in a new SSD and Bhyve? Uses 4K Physical Sector sizes by default..
So seems MSSQL will not work on newest hardware which uses 4K.

In my case I just adjusted the Bhyve settings to ,sectorsize=512 and also added a Sata/Legacy option to BVCP as from 1.8.4-release. For the others, installing into "legacy" drive will make a trick but using VHD disks also could be a solution if you like a dirty way.

P.S: 4K logical sectors are fine if you have 512B physical sectors.

No more words....

If you like the article then don't forget to share!

Is Rust better than C/C++ ?

Rust is relatively new programming language which offers full memory management and garbage collection, while C/C++ already has a decent history..

Network Update

Proudly announcing that in the past days we expanded our infrastructure and our services will become more stable and quickier at us west, us..

Windows 10/11 Disable Search and annoyings on start menu

The one of the most irritative feature on windows is a "new" start menu which sends every input into Microsoft related services. Also if you have..

BVCP 2.0.x Released

Our one of the most popular FREE-TO-USE Software BVCP reached the next milestone.Big thanks to the active community, a ton of feedbacks received..

Welcome 2024

We have been busy at 2023. Im personally very happy to see a lot of new technologies especially EV related researches.We continued to support our..

FreeBSD 14 fresh install breaks mc (Midnight Commander) subshell support

We are very happy to announce that - if you did not know already - one of the best Operating System released a new version. FreeBSD 14. This..

ZFS Replication Software

While we are working on BVCP 2.0 just another software made to handle ZFS Replications over multiple nodes. The software yet not released..

Bhyve UEFI drops into EFI shell, Linux wont boot Easy Workaround

EFI works that way that the installer places a file into a FAT32 partition in a regular directory as called "BOOT". The usual full path of..

Nexus Datalogger 2023

We're proudly present that we released out our next version of datalogger software as commerical product. Our first version of Datalogger..

MSSQL Fail to start on newer hardware

Credits and Partners