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!


DELL PERC H710 turning into JBOD for ZFS

So at this very begining of the day I picked up an oldie machine Dell T620 and decided to want JBOD for ZFS, better IOPS and easier..


2021 Annual Report

Evolving. Trusted. Doing Better. I proudly can confirm that we still put many efforts to make our infrastucture more stable more green and..


nPulse.net going dark (again)

Back in time the most of the websites were DARK, specially the tech ones and forums. Then people started to use more slick, curved and light..


sysAdmin ToolBox v2.3.0

We just uploaded the very new release of this application.We added new function called: WiFi Discovery I'm sure everyone will love that, so..


New Software (PFR)

Our new Software released under Open Source license. PFR is a cross-platform easy-to-use powerfull tool to recover broken files that caused HDD..


BVCP for FreeBSD Bhyve Released today!

I'm happily announce that, one of our greatest product just released for the public! BVCP is a Webcontrol interface for FreeBSD Bhyve aka..


Upgrade into FreeBSD Bhyve was successfull

As I told before we were started to migrate our infrastructure from Linux/KVM (FreeBSD) into FreeBSD/Bhyve (FreeBSD). I announce that we..


Hello Bhyve, Im moving in ...

We are performing an update at this weekend, there will be some interrupts in our services. Please be patient! ..


Launched BVCP Today!

FreeBSD Bhyve Web Control Panel launched today as planned as pre-release.Project started at 2021.05 month and yet ready for production use..

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