MSSQL Fail to start on newer hardware

Published Date: 2022/03/31 by: DaVieS

MSSQL Fail to start on newer hardware
MSSQL Fail to start on newer hardware

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!


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..


Big Concern: Facebook hack, Google Chrome V8 Hack, Meta Support

Many users experiences that their account leaked through Facebook Advertisement platform.The BOT change their names to Kevin Konkrete Davis and..


Maintenance

We are doing some regular maintenance at 22:00 - 02:00 UTC. Some services might be distrupted at this time. ..


FreeBSD Bhyve Webadmin | BVCP 1.9.8 Just Released

BVCP 1.9.8 features  New protocol to transmit VNC/RFB data as encrypted and compressed.Better, faster and more responsive UI.Colored..

All rights reserved nPulse.net 2009 - 2024
Powered by: MVCP 2.0-RC / BVCP / ASPF-MILTER / PHP 7.4 / NGINX / FreeBSD